Video: how to split cells with text to multiple columns in Google Sheets

Yet another splitting instrument for your Google spreadsheet toolset: Split Text add-on. It splits cells in Google Sheets by multiple delimiters at once, by text strings, by the desired position, and even by capital letters. Have a look ;)

Video transcript: Split Text add-on for Google Sheets

If you need to split cells in Google Sheets into multiple columns, we offer an advanced alternative to the standard option.

Our Split text add-on will split your cells in 4 different ways:

  1. by multiple different delimiters at a time, including custom ones
  2. by as many text strings as you specify
  3. by capital letters
  4. and by the chosen position

Let's take a closer look at all these options.
4 ways to split text to columns in Google Sheets.
You will find Split text under the Add-ons menu > in the Power Tools collection > in the Text group.

  1. The first option you'll see is Split by characters. It splits cells by 4 common delimiters; and there's also a field for any custom separators your cells may contain. On top of that, the more checkboxes you select, the more characters the add-on will split by simultaneously.

    There are also two settings at the bottom — they apply to all splitting ways, and this is something the standard tool just cannot do ;)

    • When my delimiters appear in cells one after the other, like a comma followed by a line break, the add-on will treat them as one thanks to this first checkbox.
    • As for the second one, it will replace source records with split data.

    So, I select my column A, hit Split, and get 3 new columns with the text.

  2. The next is Split by strings. Whatever delimiters your cells may have — like conjunctions or particular character or letter combinations — enter them in this field to split by them.

    See? Each item is in its own cell, and now this table is much easier to process.

  3. In case your cells contain capital letters that you can split by, this next option will do the trick. Just like that :)
  4. And the last way to split is by position. It's super handy if there are no delimiters at all. You just select the data, click at the desired position (or two) and hit Split.

    As a result, you have multiple cells with strings of the same length.

Install your Power Tools from the Google Sheets Store and have Split text and over 30 other time-savers for spreadsheets at hand.

If you have any questions, please contact us — we'll be happy to help! :)

And don't forget to subscribe to our channel so you don't miss any future videos ;)

Thank you!

You may also be interested in

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)