Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.worksheet.functions
|
|||
|
|||
Worksheet Renaming
Will this do?
Sub renameall() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Name = Application.WorksheetFunction.Proper(ws.Name) Next ws End Sub Mike "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 | |||
Worksheet Renaming | 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) |