How to Split First & Last Names Into Separate Columns For Your Google Sheet
This article explains how to split a first & last name in one column of your google sheet into two separate columns
If you wanting to include a first name in your automation, then the name or the data you want to use needs to be in it’s own column in the spreadsheet that is connected to your automation in the desktop app. This article is a step-by-step guide on how to split the first and last name into separate columns.
Start with making column headers for first and last name within your google sheet. Example shown below.
Next, in the first column and first row type in =SPLIT(COLUMN/ROW, “ “) Then click any blank cell. You’ll see the names split. Highlighted in the example below.
Next, copy the first cell you type in the formula then drag or copy and paste that formula into the rest of the column. Shown in the example below.
That will split the first and last name into separate columns. Should look similar to the example below.
