How to Split Cells in Google Sheets | Scribe

    How to Split Cells in Google Sheets

    • Alai Umerez |
    • 9 steps |
    • 18 seconds

      How to Split Cells in Google Sheets Using the Split Text to Columns Option

      1
      Choose the column or range of cells containing the text you want to divide
      2
      Click "Data" at the top menu
      3
      Select the option "Split text to columns"
      4
      In "Separator", choose the delimiters that separate your data (e.g., spaces, commas, etc.). For this example, the delimiter is a space since each word is separated by one (i.e.: Joe \* space \* Smith)
      5
      Review your newly split text

      How to Split Cells in Google Sheets Using the Split() Function

      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 "-").
      6
      Click on the cell where you want the split result to appear
      7
      Type "**=[[SPLIT]](** " and select the cell you want to split
      8
      Complete the formula by adding the delimiter "**=[[SPLIT]]**(B3, " ")
      9
      Review your newly split text