How to Convert Text to Columns in Excel
18/01/2022 Other Classes
Price: 1.00 ₹
Description
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
Comments
basictoturia
Individual
More Details