Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please can you tell me (in simple format) how you capitalize multiple cells?
Cheers |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
ASAP Utilities, a free add-in available at www.asap-utilities.com has
features which make this easy to accomplish. Vaya con Dios, Chuck, CABGx3 "Eastee" wrote: Please can you tell me (in simple format) how you capitalize multiple cells? Cheers |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A simple way is to use the UPPER function. For example - =UPPER(A2)
changes cell A2 to upper case. If this is a one shot deal then you can create this off to the side of your original data and copy back into your original cells using paste special : Values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capitalization of first word in a cell | Excel Discussion (Misc queries) | |||
Capitalization | Excel Discussion (Misc queries) | |||
Capitalization? | Excel Worksheet Functions | |||
Capitalization | Excel Discussion (Misc queries) | |||
Correct Text Case to PROPER capitalization | Excel Worksheet Functions |