Ok, I am using VBA within Excel 2000 to write an application.<BR><BR>This is what I am trying to do. Say that I have a cell with a string as a value such as 'MC,FG,ED,C,CFD". What I am trying to do is ...
I didn't realize how much time I spent on cleanups until regex let me stop.
Fix "fake" numbers, strip hidden web spaces, and join text professionally using Excel's built-in legacy and modern tools.