Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change an existing cell or cells to upper case?
how do i change an existing cell or cells to upper case?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change an existing cell or cells to upper case?
In an adjacent column, use the Upper function, as in:
=upper(a1) You can then convert this to values, and delete the original. Regards, Fred "dopy" wrote in message ... how do i change an existing cell or cells to upper case? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
How to change cell data from all upper to title case | Excel Discussion (Misc queries) | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |