Excel Text to Columns: A Step-by-Step Guide to Splitting Data
☰Fullscreen
Table of Content:
To separate the contents of one Excel cell into separate columns, you can use the 'Convert Text to Columns Wizard'. For example, when you want to separate a list of names and marks of students into two columns Name and Marks.

You can also apply.

Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.
Step 1

Step 2

Step 3

Step 4

No Questions Data Available.
No Program Data.