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.
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.