Learn how to split one column into multiple columns in Excel using the 'Text to Columns' feature (step-by-step instructions)
To do this, first, select the cells in column A, and in the Data tab on the ribbon, click "Text To Columns." In the Convert Text to Columns Wizard, select "Delimited," and click "Next." A delimiter is a character, symbol, or space that is used to separate items in a sequence.
We have to split the cells of column B into two columns, e.g., first name and last name. Steps: Select the whole dataset e.g. B4:B11. The Text to Columns Wizard will appear. Choose the Delimited option and press Next. Select the Space option and press Next. Select the Text option from the Column Data Format and adjust your Destination if necessary.