How to Separate First and Last Name in Google Sheets
Alai Umerez |
10 steps |
23 seconds
Separate First and Last Name Using the Split Text Option
1
Select the cell or cells with the names and last names you'd like to separate
2
Click "Data" in the top menu
3
From the drop-down menu, select the option "Split text to columns"
4
In the "Separator" pop-up that appears beside your selected text, open the dropdown menu
5
Choose your delimiter from the available options: Comma, Semicolon, Period, Space, or Custom
For this example, we'll select "Space" as the names and last names shown in the table are divided by spaces
6
Review your newly split text
Separate First and Last Name Using the Split Formula
Important!\
\
Before using the Split function is important to understand its formula.
The formula looks like this:\
**=SPLIT(text, delimiter)**
\
**text**: This is the cell or text you want to split
\
**delimiter**: This is the character that separates the parts of the text (like a space " ", a comma ",", or a dash "-").
7
Click on the cell where you want the split result to appear
8
Type "**=[[SPLIT]](** " and select the cell you want to split
9
Complete the formula by adding the delimiter "**=[[SPLIT]]**(F4, " ")