Using Andrew's suggestion for find and replace, with the amendments I described, I pasted the content twice into a Word document (twice because you provided only one row), then performed the find and replace steps as described. I used the option to replace four commas with one comma.
I then tried two options, both of which worked: Save the file as a text file, rename it as a csv file, and open with Excel; or create a table from text with commas as the separator, copy the table, and paste it into Excel.
|