How to Convert Text to Columns in Excel

If you want to separate one cell content into separate columns in Excel, you can use the ‘Convert Text to Columns Wizard’.

This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel.

Using this you can separate texts into columns with characters like (/,-,space, and user input).

we have already discussed how to join texts in Excel in our tutorial.

To access the Text to Column shortcut in Excel, use: ALT + A + E

https://www.basictutorials.in/how-to-convert-text-to-columns-in-excel.php