For some reason it is with the data I downloaded from Access. :o

Thanks!

"akphidelt" wrote:

You can change to all uppercase by doing

=UPPER(A1)
or lower
=LOWER(A1)

Or you can make everything where it is in the proper text format with

=PROPER(A1)

But remember that you will have to use a formula so you will need to put
this in to another column.

But for some reason I never thought that excel sorted different between caps
and non cap letters.

"Kristibaer" wrote:

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?