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?

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?

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?

=UPPER(A1)

=LOWER(A1)

=PROPER(A1)


"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?

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?

This doesn't work. Formula not recognized.

"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?

"This" being what?

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


Gord Dibben MS Excel MVP

On Thu, 28 Aug 2008 12:48:01 -0700, mATT
wrote:

This doesn't work. Formula not recognized.

"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?