Formula Library

Excel Formula To Separate First And Last Name In A List

Separate first and last name in a list with a ready-to-use formula for Excel, Google Sheets, and WPS.

Quick answer

Separate first and last name in a list.

Unified formula

ExcelWPS

=TEXTSPLIT(A2, " ")

View platform differences

Google Sheets

=SPLIT(A2, " ")

How it works

Replace the sample range (like A2:A) with your real range.
Keep the same column order used in the example.
Fill down to apply the formula to every row.

Need a custom version?

Related formulas

Excel Formula To Split Full Name In A List

Split full name in a list with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Split Full Name a column

Split full name a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Split Full Name a column

Split full name a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Split Full Name a column

Split full name a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Split Full Name a column

Split full name a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Split Full Name a column

Split full name a column with a ready-to-use formula for Excel, Google Sheets, and WPS.