How to Split Columns in a Google Docs Spreadsheet

Written by shawn farner
  • Share
  • Tweet
  • Share
  • Email

When working with data inside a Google Docs spreadsheet, you may find that you want to take the data from one cell and split it into multiple columns. For instance, a person's full name might be in cell A5. Using the Split function, you can place the person's first, middle and last names into different cells in different columns. This makes the data easier to work with. You can learn how to split columns in a Google Docs spreadsheet in just a few steps.

Skill level:
Moderately Easy


  1. 1

    Visit the Google Docs website at and sign in with your Google credentials.

  2. 2

    Click on the spreadsheet you'd like to open. The spreadsheet will appear in a new tab.

  3. 3

    Find the cell address of the cell for which you want to split the contents. For instance, if the cell is in column A in row 5, the cell's address is A5.

  4. 4

    Click on an empty cell into which you want to split the contents of your original cell. Type the following code into the cell:

    =split(A5," ")

    Replace A5 with the cell for which you want to split the contents.

  5. 5

    Press the Enter key. The contents of your original cell will be split into multiple columns depending on the number of spaces there are in the original cell. You have successfully split a column in a Google Docs spreadsheet.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.