Allow only one special character i a cell

Z

Zadig Galbaras

Hi...
Is there a way to allow only one special character i a cell?
I use the validation on the Data-menu to allow only one character in a cell,
but in this cell the only character allowed is a capital "X"
Is it possble?

--

Regards
Zadig Galbaras

--
 
B

Beege

Zadig

Pick a cell, place an X in it, validation reference to that cell

Data/Validation/List/pick cell/no drop down, no ignore blank

Beege
 
N

Nick Hodge

Zadig

Select 'List' from the data validation list and enter X in the source box,
uncheck in-cell dropdown

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 
Top