Guide
How to Separate First and Last Names in Google Sheets
Easily split full names into first and last names using Google Sheets functions. This can help in organizing data and making it more manageable for analysis.
Open Google Sheets and ensure that you have a column with full names, with first and last names combined in a single cell.
Click on the column containing the full names and insert two blank columns to the right if they are not already available.
Select the column with full names, then go to the "Data" menu at the top and choose "Split text to columns."
A separator detection popup will appear; by default, Google Sheets detects spaces, but you can manually select "Space" as the delimiter.
The full names will be automatically split into two separate columns—one for first names and another for last names.
If you need to reformat or adjust, you can rename the new columns as "First Name" and "Last Name" for better organization.