Font Case in Excel-HELP!!!!

[Kristibaer]

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?

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[akphidelt]

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.

 

[Gaurav]

=UPPER(A1)

=LOWER(A1)

=PROPER(A1)

 

[Kristibaer]

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

Thanks!

 

[mATT]

This doesn't work. Formula not recognized.

 

[Gord Dibben]

"This" being what?

Did you try =UPPER(cellref) or =LOWER(cellref) in helper cells?


Gord Dibben MS Excel MVP