Thread: [Solved] convert text to tables
View Single Post
 
Old 03-17-2015, 10:22 AM
BruceM BruceM is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2015
Posts: 41
BruceM is on a distinguished road
Default

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.
Reply With Quote