Benefits of Staff au...
Tutoring - Private Lessons
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).
To access the Text to Column shortcut in Excel, use: ALT + A + E
Comments