I know how to remove leading apostrophes but I can't figure out how to remove
trailing apostrophes but still leave a number as text.

For example, I have a number like 018" in my spreadsheet. Of course, it is
actually " 018" when you go to edit the cell. I want to be able to remove
the " after the 8 but leave the cell as " 018.

My leading apostrophe macro doesn't work and if I use a find and replace
command, it removes both apostrophes and leaves me with 18 as the cell value.

What am I missing? Thanks