Hi
I have the following formula all over a spreadsheet
<colgroup><col></colgroup><tbody>
#='Week 1'!I14
#='Week 1'!J14
#='Week 1'!K14
#='Week 1'!L14
</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...