Follow

CSV Opened in Excel has everything in the first cell

Microsoft Excel has a function called "text to columns" which you can use to separate the values if they are separated by commas. This functionality in Excel is a powerful tool that allows users to split a single column of text into multiple columns. This feature is especially useful when different pieces of information are combined into a single column. Here's a step-by-step guide on how to use the Text to Columns functionality in Excel.

 

For Windows and Microsoft Office 2019

1. Open Microsoft Excel.

2. If the file is a CSV, select column A, entirely.

3. Then click on the "Data" tab and in the Data Tools group, click on Text to Columns option:

Click Text to Columns

4. The following dialog box appears. Choose Delimited and click on Next:

Convert Text to Columns Wizard - Step 1

5. Clear all the checkboxes under Delimiters except for the Comma check box. Then, click Next.

mceclip0.png

6. Select "General" as data format and click on finish: 

mceclip1.png

Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different checkboxes. You get a live preview of how your data will be separated.

 

For macOS

1. Open Microsoft Excel.

2. Select column A, entirely.

3. Then click on the "Data" tab and select: "Text To Columns" option, as follows: 

4. Follow the same steps as described for the Windows option. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments