To split the contents of a cell Excel into separate columns, you can use ‘Convert Text to Columns Wizard’. For example, when you want to split a list of full names into first and last names.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Split content into separate columns in Excel
1. Select the area you want to separate the content.
2. On the Data tab, in the Data Tools group, click Text to Columns.
3. Select Delimited and click Next.
4. Deselect all checkboxes in Delimiters except Comma and Space.
5. Click Finish.
Result:
In addition, you can also view many other excel articles here.
