Excel Guides

Separating Names into Individual Columns in Excel

There are a few different ways that you can separate names into individual columns in Excel. One way is to use the Text to Columns feature. To do this, first select the column that contains the names that you want to split. Then, go to the Data tab on the ribbon and click on the Text to Columns button. In the Convert Text to Columns Wizard, select Delimited as the file type and click Next. On the next page, check the Comma option under Delimiters and click Next. Finally, click Finish.

Another way to split names into individual columns is to use a formula. For example, if you have a list of names in column A and you want to split them into first name and last name columns in columns B and C, you could use the following formula in cell B2:

=LEFT(A2,FIND(" ",A2)-1)

And then use this formula in cell C2:

=RIGHT(A2,LEN(A2)-FIND(" ",A2))

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.