LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
C Glenn
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert numbers with apostrophe's (ex. 219'2) to decimals? Kaci Excel Worksheet Functions 2 June 15th 05 03:48 PM
Removing trailing spaces from cells ? Don Guillett Excel Worksheet Functions 0 April 10th 05 03:32 PM
How do I stop excel removing zeros? tomcat Excel Discussion (Misc queries) 2 January 21st 05 05:40 PM
Removing ' character from cells Don Excel Discussion (Misc queries) 5 December 21st 04 05:41 PM
How do I obtain Curly quotes and apostrophes in Excel? Samito Excel Discussion (Misc queries) 1 December 7th 04 12:30 PM


All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"