Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 03-17-2015, 10:22 AM
BruceM BruceM is offline convert text to tables Windows 7 64bit convert text to tables 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
 

Tags
convert text to table



Similar Threads
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
convert text to tables Convert image-text hybrids into plain text 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft