How to Separate First
and Last Names in
Google Sheets

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.