81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

What are the common questions about the SPLIT formula?
What is the syntax of the SPLIT formula? SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
What does the SPLIT formula do? Divides text.
How do I specify the delimiter in the SPLIT formula? Set the delimiter in the 2nd argument of the SPLIT formula.
Can the SPLIT formula be used to split text into rows as well as columns? Yes if you combine it with the TRANSPOSE() formula
What happens if the text being split doesn't contain the specified delimiter? Find out!

How can the SPLIT formula be used appropriately?
To split a list of names, email addresses, or other data into separate columns or rows.
To extract specific data from a larger string of text.
To split a cell containing multiple values into separate cells.

How can the SPLIT formula be commonly mistyped?
The SPLIT formula can be misspelled as SPIT, or SPLUT, or SLIPT, or SLIT, or SPILL, or PLITS

What are some common ways the SPLIT formula is used inappropriately?
Trying to split text that doesn't contain the specified delimiter.
Using the SPLIT formula to split text that has inconsistent or unpredictable formatting.
Using the SPLIT formula to split text that requires complex parsing.

What are some common pitfalls when using the SPLIT formula?
The SPLIT formula may not work correctly if the delimiter appears multiple times in a row, or if there are multiple delimiters in a row.
The SPLIT formula may split text into more or fewer columns/rows than expected if the text contains extra spaces or other formatting issues.
The SPLIT formula can be slow or resource-intensive if used on a large dataset.

What are common mistakes when using the SPLIT formula?
Forgetting to specify the column or row where the split text should be placed.
Forgetting to select the correct range of cells to apply the formula to.
Not double-checking the output of the SPLIT formula to ensure it's correct.

What are common misconceptions people might have with the SPLIT formula?
The SPLIT formula can only split text into columns, not rows.
The SPLIT formula can only split text based on a single delimiter.
The SPLIT formula always works perfectly and doesn't require any additional tweaking or editing.

How To Use in Sheets

SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

External Links

Word Count, Unique Word Count, Most Popular Words - Google Sheets

Learn how to count words, get unique word count, calculate word frequency & get a list of most popular words with their counts in a Google Sheets spreadsheet.

12Better Sheets Tutorials

Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.
How to figure out a percentage score when our reporting numbers are a formatted in a particular way. In this case we have a score and then a slash and then the total possible score in a single cell. We go through each option of solution and try to derive a solution that is both useful in the exact situation and possibly useful for other problems too.

We find that the Query formula and other solutions are inflexible or time intensive. We want a solution that does actually solve the problem at hand, in a quick way, and also is easy to edit and flexible to solve other problems.
Revolutionary Method to Manage Your Video Stories! Learn how to delete old videos in just 24 hours. Keep your content fresh and engaging. Click here for the ultimate guide. 
We go deep into the syntax and usage of the SPLIT() formula.
Count your words inside a sheet. Great for ad writing, novel writing, or if you need to meet minimums.
Track your goals with a thermometer.
There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.


Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Go from nothing to a working PR agency. Capture sites, and Send email via script