I'm running a web query that gets golf scores from a web page. The numbers download with a ' (apostrophe) prefix. I can't do a sum or any other function until I remove the ' (apostrophe). I ran into a similar problem before where the prefix was a space. I was able to use the TRIM function to clean up those data. Is there a function that will remove the apostrophe?
Bookmarks