Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
=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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Case in Excel-HELP!!!!
"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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert font to lower case | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
Changing the font case size across a worksheet | Excel Discussion (Misc queries) | |||
Excel Font Effects should include Upper Case | Excel Worksheet Functions | |||
Change the font case of all cells in the worksheet to uppercase? | Excel Worksheet Functions |