Better Sheets

How To Use SPLIT() Function in Google Sheets

Description

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

How To Actually Use SPLIT() in Sheets

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

Try SPLIT yourself

In cells A1:A5, you have names formatted as 'First Last'. Use the SPLIT() formula in cell B1 to separate the first and last names into different cells. The formula should split the text by the space character.

Your formula

Hints (2)

Locale Separator ,

Official Docs

20 Better Sheets Tutorials

Create a Sheet of Sheets for Project Management and/or Data Management

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!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

Count How Many Subscribers In a Company by BetterSheets.co

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.

Intermediate

ARRAYFORMULA() COUNTIF() LOWER() SORT() SPLIT() +1 more

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

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.

Advanced

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script

Intermediate

ARRAYFORMULA() FILTER() JOIN() SPLIT()

Build a Thermometer for Savings Goals

Track your goals with a thermometer.

Intermediate

CONCATENATE() IF() REPT() ROUND() SPLIT() +1 more

How Does Split Work?

We go deep into the syntax and usage of the SPLIT() formula.

Beginner

SPLIT()

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Beginner

FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more

How to Add YouTube Thumbnails

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.

FIND() IFERROR() INDEX() SPLIT() SUBSTITUTE()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

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.

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Add a Word Count to Google Sheets

Count your words inside a sheet. Great for ad writing, novel writing, or if you need to meet minimums.

COUNTA() IF() ISBLANK() SPLIT()

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

JOIN() REGEXREPLACE() SPLIT() TRUE()

Spreadsheet Automation for Beginners

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: https://bettersheets.co/courses/spreadsheet-automation-101

Get the AI GPT-3.5 and GPT 4 code: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Better Sheets members can get the code and the sheet in the video below.

Beginner

INDEX() SPLIT()

Kristy Asks How to Get Percentages from Scores

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.

Beginner

ARRAYFORMULA() IF() INDEX() ISBLANK() LEFT() +3 more

Duplicate Everything For Each Unique Value

Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.

Intermediate

ARRAYFORMULA() CONCATENATE() JOIN() SPLIT()

Get Instagram Follower Accounts in Google Sheets

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.

Intermediate

IMPORTXML() INDEX() SPLIT()

Create a Branded Lead Magnet from Qualitative Data

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.

Intermediate

AVERAGE() COUNTA() COUNTIF() FIND() HYPERLINK() +7 more

YouTube Thumbnail A/B Test Results

Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.

Intermediate

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Learn simple keyboard shortcuts to save you time

Learn some simple keyboard shortcuts.

Intermediate

SPLIT()

Every Possible Permutation - Solved with Spintax

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

Intermediate

CONCATENATE() IF() ISBLANK() JOIN() SPLIT()

Pick a Raffle Winner with Number of Tickets

Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.

Advanced

ARRAYFORMULA() IF() INDEX() JOIN() RANDBETWEEN() +3 more

Learn more about the SPLIT() formula:

Generate a SPLIT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses SPLIT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a SPLIT() formula

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons