How to Split Names in Excel?

Use Flash Fill: type the first split result in adjacent columns, then press Ctrl+E

Use Text to Columns: select the names, go to Data, choose Text to Columns, and split by delimiter

Use formulas for first and last names:

First name: `=LEFT(A1,FIND(” “,A1)-1)`

Last name: `=RIGHT(A1,LEN(A1)-FIND(” “,A1))`

Use `TEXTSPLIT` in Excel 365: `=TEXTSPLIT(A1,” “)`

Use `TEXTBEFORE` and `TEXTAFTER` in Excel 365:

First name: `=TEXTBEFORE(A1,” “)`

Last name: `=TEXTAFTER(A1,” “)`

Use `FILTERXML` for multiple parts: `=FILTERXML(““&SUBSTITUTE(A1,” “,”“)&”“,”//s”)`

Use Power Query: select the data, choose Data, then From Table/Range, and split the column by delimiter

Use Find and Replace to standardize separators before splitting if names have commas or extra spaces

Use `TRIM` to remove extra spaces before applying split methods

Use `PROPER` after splitting if you need proper capitalization