Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Replace function to change worksheet names
I have a file with multiple worksheets (one for each day). I want to change
the name of each worksheet to the name of the month. For example, I want to change 'Nov' to 'Dec' in all of the worksheets in the file. When I use the Replace function, it says it can't find the data it is looking for. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Replace function to change worksheet names
Hi Rizello,
You try to replace a text Nov to Dec, or you have dates like 11/1/2006 formated as Nov? if it's a date try to replace 11 to 12, DO NOT FORGET to do a backup of your sheet before. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "rizello" escreveu: I have a file with multiple worksheets (one for each day). I want to change the name of each worksheet to the name of the month. For example, I want to change 'Nov' to 'Dec' in all of the worksheets in the file. When I use the Replace function, it says it can't find the data it is looking for. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Replace function to change worksheet names
AFAIK, Rreplace does not look at sheet names. Renaming sheets is a manual
process, unless you create a VBA macro. It sounds like you are doing this each month. You could get aorund this by not including the month in the sheet names, and, and keeping the month in the file name. The sheet name is just the numeric day. "rizello" wrote: I have a file with multiple worksheets (one for each day). I want to change the name of each worksheet to the name of the month. For example, I want to change 'Nov' to 'Dec' in all of the worksheets in the file. When I use the Replace function, it says it can't find the data it is looking for. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Replace range names with cell references? | Excel Worksheet Functions | |||
use replace command to change the contents of formulas | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |