How to Convert Text to Columns in Excel
Jan 18, 2022 04:56:08 AM
BEML layout, 5th Stage, Opp. Rajsri Apartment Rajarajeshwarinagar,
Bangalore, Karnataka,
India 560098
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
https://www.basictutorials.in/rounddown-function-in-excel.php