Hi
I have the following formula all over a spreadsheet
<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.
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.