公式库

Excel Formula To Separate First And Last Name a cell

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

快速答案

Separate first and last name a cell.

统一公式

ExcelWPS
=TEXTSPLIT(A2, " ")
查看平台差异

Google Sheets

=SPLIT(A2, " ")

使用说明

需要定制版本？

相关公式

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.