How to Separate First and Last Name in Google Sheets | Scribe

    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

      information ordinal icon
      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, " ")
      10
      Review your newly split text