How to Convert Text to Columns in Excel
Jan 13, 2022 10:00:20 AM
1st Main Rd, Chamrajpet, Bengaluru, Karnataka 56001,
Bangalore, Karnataka,
India 1
914188188
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