What is the fastest way to remove "-" in multiple worksheets?

[alexxgalaxy]

Hi

I've used DataPig to pass out the data on multiple tabs and their names all end with "-". I want to make it away. Could anyone tell me what is the fastest way to remove it from the multiple worksheets's name? Thanks.

[Miraun]

If there are no "-"s that you want anywhere in any worksheet,

Ctrl + F
Find and replace
Look for -
Replace with (null)

By null, I mean the absence of anything in the replace with field... not the value/text Null itself.

Find all.... Bam, a billion replacements, and no more "-"s

[alexxgalaxy]

If there are no "-"s that you want anywhere in any worksheet,

Find all.... Bam, a billion replacements, and no more "-"s

I'm afraid this didn't serve the purpose. As mentioned, the names of the worksheet all end with "-" and I would like them gone. Only the "-" in the name in all worksheets, not all "-" in anywhere of every worksheets.

[Chance2]

Try this:

Note: this code will replace all "-" in the sheet name...

Please Login or Register  to view this content.

[alexxgalaxy]

It worked perfectly. Thank you!