ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 793
- Office Version
- 365
- 2019
- Platform
- Windows
I have a very large data set. where data that leads with zero will also lead with an apostrophe example ('0781). i tried different ways to try to resolve. copy and paste values, text to columns, comma delimited. with no success. if i double click manually into the cell it yields the result I need. problem is the data set is 10,000 rows so i can't do that. Does anyone have a quick way to resolve? I am open for VBA or anything at this point