I work with a program called Primavera. The Excel export from the program adds an apostrophe to the beginning of every cell. I have tried several solutions that I could Google, but none of them were working for me. I tried cell.value = cell.text, pasting only values on top of the data, multiplying by 1, and text to columns. The text to columns worked the best, but I have over 32,000 rows with at least 10 columns. Doing that for so much data just wasn't good enough.
I finally came up with this vba code that works in a flash. It removes the apostrophes for everything on the sheet. If you have any ideas for improving it, let me know. I'm just posting here to share in case anyone else has this same problem.
Bookmarks