Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing errant apostrophes
I'm working with a spreadsheet produced by a scraper. For reasons that
I can only guess and am powerless to change, it places an apostrophe before some of the numbers (IOW, one might imagine that it believes them to be numeric strings). I was hoping to find a way to remove them en masse, through search and replace perhaps. But the search half of the process doesn't know how to look for an apostrophe at the beginning of a cell. It seems that those don't count. Any ideas on how this could be automated? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert numbers with apostrophe's (ex. 219'2) to decimals? | Excel Worksheet Functions | |||
Removing trailing spaces from cells ? | Excel Worksheet Functions | |||
How do I stop excel removing zeros? | Excel Discussion (Misc queries) | |||
Removing ' character from cells | Excel Discussion (Misc queries) | |||
How do I obtain Curly quotes and apostrophes in Excel? | Excel Discussion (Misc queries) |