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

[shreked12]

Hi

I have the following formula all over a spreadsheet

#='Week 1'!I14

#='Week 1'!J14

#='Week 1'!K14

#='Week 1'!L14

<colgroup><col></colgroup><tbody>
</tbody>

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