How to Convert Comma-Separated Text Into Rows in Ms. Excel

Select cells - How to Convert Comma-Separated Text Into Rows in Ms. Excel 3

One day I opened one of my Excel files and found it really messed up. Instead of separated by cells, each data is divided with a comma which only makes the whole document can’t be processed. There are tons of data and it’s impossible to fix them manually.

Instead, as it turns out, Microsoft Excel does offer a function that lets you convert a comma-separated text into rows in an instant. The result is a lot better than I expected. Each value is now in its own cell, clean and easy to read. To learn this trick, follow the guide below!

1. Open the Excel document that wants to be fixed.

Excel document - How to Convert Comma-Separated Text Into Rows in Ms. Excel 5

2. Select all the cells that contains a comma-separated text.

Select cells - How to Convert Comma-Separated Text Into Rows in Ms. Excel 7

3. Now head to Data > Text to Columns.

Advertisement
text to columns - How to Convert Comma-Separated Text Into Rows in Ms. Excel 9

4. Select Delimited and click Next.

delimited - How to Convert Comma-Separated Text Into Rows in Ms. Excel 11

5. Tick the Comma option, then hit Finish.

finish 1 - How to Convert Comma-Separated Text Into Rows in Ms. Excel 13

6. The comma-separated text has been converted into rows.

separated - How to Convert Comma-Separated Text Into Rows in Ms. Excel 15

As you might have noticed, the feature is not limited to just comma. It can run from other delimiters as well, such as tab, semicolon, space, and virtually, anything else. I hope this guide helps you!

Advertisement

Leave a Comment

Your email address will not be published.