Hi,
Sometimes we work with Excel files that have a leading apostrophe as a leading character. I'm not referring to the hidden apostrophes Excel puts in front of numbers formatted as text, but clearly visible apostrophes.
I need a macro that can run through a column of data and strip the leading apostrophe from each cell where it exists.
Right now, I'm using this:
This works fine for manually highlighting the column and running the macro. But I would like the macro to run automatically when the file opens, or maybe even constantly. Any suggested solutions?
Thanks,
hk106
Bookmarks