---

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

---