Remove Trailing Apostrophe

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Put this formula in a helper column:

=LEFT(A1,LEN(A1)-1)

and copy down the column. Then highlight all the cells with the
formula in, click <copy>, then Edit | Paste Special | Values (check) |
OK, then <Enter>. This will fix the values, so that you could delete
the original column of data you had.

Incidentally, although you refer to the symbol as an apostrophe ('),
what you actually used in your example were quotes (").

Hope this helps.

Pete
 
Back
Top