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))