Split Text in Excel & Google Sheets
Split text by delimiter, extract first or last name, or split by comma. Free formula examples. No signup required.
Split by Delimiter
Split text using TEXTSPLIT (Excel 365 / Google Sheets).
=TEXTSPLIT(A2, ", ")Extract First Name
Get the first word (first name) from full name.
=LEFT(A2, FIND(" ", A2)-1)Extract Last Name
Get the last word (last name) from full name.
=RIGHT(A2, LEN(A2)-FIND("*", SUBSTITUTE(A2, " ", "*", LEN(A2)-LEN(SUBSTITUTE(A2, " ", "")))))Split by Comma
Split comma-separated values into columns.
=TRIM(MID(SUBSTITUTE(A2, ",", REPT(" ", 100)), (1-1)*100+1, 100))For more text functions, see TRIM, LEFT, RIGHT, and Data Cleaning.