Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transforming many cells of all caps into first letter capitals onl
I have approximately 600 cells in a single column, with each word in each
cell in all caps. It looks something like this: A HARDWOOD FLOORS CARPETING OAK FLOORS etc. I would like to make it so my data looks like this A Hardwood Floors Carpeting Oak Floors Simply, the first letter of each word capitalized instead of everything in all caps. Since it's 600 cells, I need to do this en masse without having to retype every cell. Any help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fix all caps text to first letter caps | Excel Discussion (Misc queries) | |||
How do i make every first letter caps? | 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) | |||
Changing text from all caps to first letter cap | Excel Discussion (Misc queries) |