| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hOW DO i TURN TEXT INTO ALL CAPS?
I have written info in caps and lower case. I need it to be all caps. Is the
a command to get it to change? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hOW DO i TURN TEXT INTO ALL CAPS?
Say you have text in column A and want to convert it.
In B1 enter: =UPPER(A1) and copy down Then copy column B and paste/special/values back onto column A -- Gary''s Student - gsnu200812 "big D" wrote: I have written info in caps and lower case. I need it to be all caps. Is the a command to get it to change? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hOW DO i TURN TEXT INTO ALL CAPS?
F1
Upper -- David Biddulph "big D" wrote in message ... I have written info in caps and lower case. I need it to be all caps. Is the a command to get it to change? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does the word typed "true" automatically turn to ALL CAPS? | New Users to Excel | |||
| fix all caps text to first letter caps | Excel Discussion (Misc queries) | |||
| Why does caps lock automatically turn on? | Excel Discussion (Misc queries) | |||
| How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
| excel sheet all caps and needs to be only the first letter caps.. | Excel Discussion (Misc queries) | |||
Linear Mode
