Arrow left
Back to product guides
Google Sheets Tips

How to Split Texts into Columns in Google Sheets

In this article, you will learn how to separate texts into columns in Google Sheets.

How to split texts horizontally in Google Sheets

  1. When you paste texts you want to separate, left-click the board icon popping up around the bottom right corner of the range the texts are pasted.
  2. Choose “Split text to columns”.
  3. Select the proper separator from a pull-down list → Left-click or choose “Custom” → input a custom separator → press the “Enter” key.
How to split texts into columns when you paste them on Google Sheets

In a separator menu, you can see “Detect automatically”*, “Comma”, “Semicolon”, “Period”, and “Space” as default settings. Note that “Detect automatically” only works when the texts contain common regularity (e.g., each text begins with the same number of letters and space) and that a chosen separator doesn’t appear in each split text.

What the separator menu looks like in Google Sheets

How to split existing texts in Google Sheets

  1. Select the text you want to separate.
  2. Navigate to the “Data” tab → “Split text into columns”.
  3. Select the proper separator from a pull-down list → Left-click or choose “Custom” → input a custom separator → press the “Enter” key.
How to split the existing texts into columns in Google Sheets

How do I split text vertically in Google Sheets?

Unfortunately, the Google Sheets function introduced in the sections above doesn’t allow you to split text vertically when you paste a data set. So, you need to use the TRANSPOSE function or Special Paste after you separate texts horizontally.

What are the other tips on text in Google Sheets?

Check the following articles if you are interested in formatting text in cells.

How to Indent Texts in Google Sheets: Explained

How to Wrap Text in Cell in Google Sheets

How to Capitalize All Letters in Google Sheets

How to Make All Letters Lowercase in Google Sheets

How to Capitalize the First Letter in Google Sheets

How to Align Text in Google Sheets

Do you want to learn how to combine or split text in Google Sheets?

How to Combine Texts in Google Sheets

How to Use the CONCATENATE function in Google Sheets

How to Use SPLIT Function in Google Sheets

Why don’t you double-check the spelling of your texts before printing or closing Google Sheets?

How to Spell-check in Google Sheets

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711