Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Renaming
I have multiple Excel spreadsheets containing data that is all upper case. I
would like to modify the documents so that the only the first letter of each word is upper case and the rest are lower. There is a substantial amount of data, so manually performing this process would be extremely time consuming. Is there a way to use formulas to accomplish this automatically? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Renaming
Eric,
Sticking to a single thread is most likely to get an answer. "Eric" wrote: I have multiple Excel spreadsheets containing data that is all upper case. I would like to modify the documents so that the only the first letter of each word is upper case and the rest are lower. There is a substantial amount of data, so manually performing this process would be extremely time consuming. Is there a way to use formulas to accomplish this automatically? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Renaming
The function PROPER() does exactly that, it transforms "THIS IS MY EXCEL
BOOK" into "This Is My Excel Book". Eric wrote: I have multiple Excel spreadsheets containing data that is all upper case. I would like to modify the documents so that the only the first letter of each word is upper case and the rest are lower. There is a substantial amount of data, so manually performing this process would be extremely time consuming. Is there a way to use formulas to accomplish this automatically? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get macro to run on any worksheet without renaming the sheet? | Excel Discussion (Misc queries) | |||
Problem renaming a worksheet tab | Excel Discussion (Misc queries) | |||
Renaming Worksheet without using mouse?? | Excel Discussion (Misc queries) | |||
renaming worksheet tabs | Excel Discussion (Misc queries) | |||
need help renaming a worksheet | Excel Discussion (Misc queries) |