Formulas > =SPLIT()
How to Use SPLIT() in Google Sheets
Description
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.
Hints (2)
-
Remember to specify the delimiter as a space.
-
Make sure to apply the formula down to cover all names in A1:A5.
Better Sheets Tutorial
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.
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 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.
Learn simple keyboard shortcuts to save you time
Learn some simple keyboard shortcuts.
Take a list and make it Vertical, Using Split Join or RegexReplace
Create vertical lists in Google Sheets.
Build a Thermometer for Savings Goals
Track your goals with a thermometer.
Create a PR Agency From Scratch
Go from nothing to a working PR agency. Capture sites, and Send email via script
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.
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.
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.
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.
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.
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.
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.
Duplicate Everything For Each Unique Value
Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.
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.
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.
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
→ Get Spintax
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.
More related tutorials
Transcript-matched member videos for SPLIT(). Click through to watch.
Calculate ROAS in Google Sheets
Write Apps Script to Create a New Google Sheets Formula
How to Iterate Counting Blank Cells in Google Sheets
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