I have a problem that I'm not sure if its able to be fixed with a macro or not, but I'd sure like it to be.
I download a lot of leads for our company and the file that I received them in is a .csv file - I opened it up and I have column issues. Anywhere there's a comma, obviously, it got split - so, in a company column that ends in ", Inc.", the "Inc." got shoved to the next column, shoving over every column after that... there's a lot of these.
Is there a way to automate a fix???? Even if its not perfect, just by finding a "Inc" (and some other known culprits) in column B and adding it to the end of column A and moving over the following columns would help out tremendously!
Bookmarks