If you do datasort and select options you can remove the
case sensitivity. The default is not case sensitive

--


Regards,


Peo Sjoblom

"Kristibaer" wrote in message
...
Is there a way to change the font case in Excel to all caps or all lower
case? I need to sort a column and have mixed fonts that are interferring
with
my sort and I do not want to do this in Word.

If not, is there a way to make Excel ignore font setting?