Avatar of DougDodge

asked on 

Remove preceding apostrophes.....

I receive many dumps from a Database that has every cell with a leading apostrophe. The attached sheet has a macro that when run will remove the apostrophe from cells that contain dates or numbers, but will not remove the preceding apostrophe from text. I hope to get the macro modified to remove all preceding apostrophes.
Visual Basic ClassicMicrosoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon