How to Convert Comma Separated Text Into Rows with Excel

The other day I had to convert 138 what I call Power Words which were separated by commas into rows. Seems simple enough but if you do a search on Google for that process you may come up with some quirky answers that may confuse you more than help you.

What I came up with is a very simple method of Converting Comma Separated Text Into Rows using Microsoft Excel. I even made another How-to Video Tutorial showing you each and every step found below. As always send me your questions and requests through he commenting section on my blog or YouTube videos.

And now on to the How-to Solve This Problem with Microsoft Excel

Step 1. Copy the comma delimited text into your clipboard from your text editor or Microsoft Word.

Step 2. Fire up MS Excel and paste the comma separated text into a cell.

Step 3. Click on the Data Tab and then select Text to Columns.

Step 4. Now select Delimited as that is the type of Data we are working with.

Step 5. My data is separated by comma's so I unselected the TAB delimiter and selected the Comma delimiter and clicked NEXT.

Step 6. Select your Data Type, mine is text so I left the default option of General selected and clicked Finish.

Step 7. All the words have now been separated into Columns. Now highlight the entire row by clicking on the number.

Step 8. Right click the selection and choose Paste Special.

Step 9. Select Transpose and you are DONE!

Step 10. Celebrate, you're one step closer to finishing whatever you are working on!

Here's the Video Instructions which I taped in 1080p high definition.

BTW: If you ever need help with Estimated Remodeling Costs Online check out Simply Additions Home Remodeling!

 

Add comment

Please do not swear, use strong sexual language, or just act like a dumb jerk because I don't allow that here.


Security code
Refresh




Latest Posts

Written on 04/24/2015 by Voitek Klimczyk
gods-swift-kick-changed-me DISCLAIMER: What you are about to read is 100% FACT, the information can be verified by me, my family, my friends, and various online...
Written on 02/26/2015 by Voitek Klimczyk
 Did Apple really kill my iPad 2 so I would be forced to upgrade? So do you think the world's favorite technology brand finally overstepped their...
Written on 02/23/2015 by Voitek Klimczyk
use-simple-hack-to-free-up-major-hard-drive-space-symbolic-linksFree Up Major Hard Drive Space with Symbolic Links for Windows Recently my SSD hard drive (Drive C:\) was running  very low on space, and I didn't...
Written on 06/27/2014 by Voitek Klimczyk
car-humor-priceless-moments-worth-sharingHey everyone knows that you have to put oil in your car, so what's so bad about this lady doing just that?
Go to top