In Excel, you can take a cell and split its text across columns in a number of ways. The easiest of these is to use the Text to Columns command under the Data menu in Excel.
For example, if you have a cell that contain both first and last names, you can use the Text to Columns command to split the data in each cell across multiple columns using a delimiter, a special character that indicates at what point data should be split. In this example, we will use a space as the delimiter.
To split text in a cell across columns:
- Select the cells you wish to affect.
- In the Data menu, click Text to Columns.
- In the Wizard, select Delimiter, then click Next.
- In the Delimiters area, check Space, then click Finish.
Before Text to Columns
After Text to Columns