How to split cells in Google Sheets

Split your text to multiple columns by several different characters at once, by certain text strings, by capital letters, or by the desired position. Get Split Text from the Google Sheets store: https://workspace.google.com/marketplace/app/power_tools/1058867473888

Visit the help page for Split Text:
https://www.ablebits.com/docs/google-sheets-split-text-column/

Learn more about Power Tools and its other 30+ add-ons on our website:
https://www.ablebits.com/google-sheets-add-ons/power-tools/index.php

00:04 Introduction to Split Text
00:34 Run Split Text
00:42 Split values by characters
01:01 Extra settings
01:36 Split by strings
01:57 Split by capital letter
02:06 Split by position
02:24 Wrap-up

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

#split #texttocolumn #googlesheets #spreadsheet #ablebits

---

Closed Caption:

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.
You will find Split text under the Add-ons
menu,
in the Power Tools collection,
in the Text group.
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 the split data.
So, I select my column A,
hit Split,
and get 3 new columns with the text.
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 :)
In case your cells contain capital letters
that you can split by,
this next option will do the trick.
Just like that :)
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 the strings of the same length.
Install your Power Tools from the Google 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! :)