![]() |
#8
|
|||
|
|||
![]()
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. |
Tags |
convert text to table |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert Text To Table: Separate text at (Other)? | tinfanide | Word VBA | 2 | 01-12-2015 05:26 AM |
![]() |
morlack | Excel | 4 | 12-03-2014 05:29 PM |
convert tables to fillable forms in word | expert4knowledge | Word | 1 | 02-13-2014 03:06 AM |
My plain text post got converted to rich text in a reply, how to convert it back? | david.karr | Outlook | 0 | 01-05-2012 09:46 AM |
Convert Number to Text | devcon | Word | 0 | 07-10-2010 01:16 AM |