Formulas > =SPLIT()

How To Use SPLIT() Function in Google Sheets


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 Actually Use SPLIT() in Sheets

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

18Better Sheets Tutorials

I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.

Learn more Automation:

Get the AI GPT-3.5 and GPT 4 code:

Better Sheets members can get the code and the sheet in the video below.
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.
I will show you how to create a hack to retrieve Instagram follower accounts from any Instagram page using import XML. I will explain the step-by-step process, including how to identify the XML, split it, and extract the follower account. Follow along and try it out yourself.
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
Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.
Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.
The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.
Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax

Learn more about the SPLIT() formula:

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.

Generate a SPLIT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.