Allow only one special character i a cell

  • Thread starter Thread starter Zadig Galbaras
  • Start date Start date
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

--
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare areas 3
Formatting text.. 2
Eliminating cells with non-matching characters 1
How to delete here and there in a worksheet.... 1
Square character(s) in cells 2
code to dis[play a message if the active cell contains an asteric 2
Autocopy the first cell with more than 30 characters to a different sheet? 1
where does a character appear in a cell? 4

Back
Top