Can a macro delete certain symbols and move data back one space

[shreked12]

Hi

I have the following formula all over a spreadsheet

[TABLE="width: 123"]
<colgroup><col></colgroup><tbody>[TR]
[TD] #='Week 1'!I14 [/TD]
[/TR]
[TR]
[TD] #='Week 1'!J14 [/TD]
[/TR]
[TR]
[TD] #='Week 1'!K14 [/TD]
[/TR]
[TR]
[TD] #='Week 1'!L14 [/TD]
[/TR]
</tbody>[/TABLE]

Is there a macro that will delete the # sign on all cells that have it in and then move the rest of the data back one space so the = is where the # was and all the other data moves back with it.

 

[brncao]

Find and Replace...

Find: #=
Replace: =

 

[Rick Rothstein]

Assuming there are no # signs in your formulas other than those you want removed, select all of your cells and call up Excel's Replace dialog box (press CTRL+H), put a # sign in the "Find what" field, leave the "Replace with" field blank, then press the "Options>>" button and make sure the "Match entire cell contents" checkbox is not checked, then click the "Replace All" button.

 

[shreked12]

Youre a star. Thanks