Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Trailing Apostrophe
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Trailing Apostrophe
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 On Aug 10, 12:18 am, Dave P wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove the apostrophe | Excel Discussion (Misc queries) | |||
Excel 2002 : How to remove trailing spaces ? | Excel Discussion (Misc queries) | |||
'09:00AM trying to get remove the apostrophe | Excel Discussion (Misc queries) | |||
remove trailing spaces | Excel Discussion (Misc queries) | |||
Remove apostrophe | Excel Worksheet Functions |