I have a CSV file that is missing a comma in front of each row. I found a link somewhere a few weeks ago that worked great, now I can't find it again. It said to open up CSV file with excel, add column in front of column A. Then type a formula or something into box A1. Then when saving to CSV, that column would then be recognized as a delimited column. Hope this makes sense to somebody. It worked perfectly. Quick and simple.
Hi Glen S,
Welcome to the Forum,
Assuming the CSV text is in Col A add 2 columns to the left of Col A.
In the new A1 put a , (comma)
In B1 enter A1&C1 and copy down
Then select Col B, copy and paste special (into B1) and select Values.
Haven't got your CSV file to test it on but it should work.
Regards
peterrc
Last edited by peterrc; 12-18-2019 at 11:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks