Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 288: Divide and Conquer! (Text Splitting)
Hi Reader,
Welcome to the Google Sheets Tips newsletter #288, your Monday morning espresso, in spreadsheet form!
A big thank you to this week's sponsor:
➜ New videos on YouTube
Check out my newest video tutorials on YouTube:
🎥 How to create Barcodes In Google Sheets
And here's something for you formula aficionados:
🎥 A play-it-through chess game in a single formula
There's also an accompanying blog post if you prefer to read about how this crazy LET + LAMBDA formula was built.
_______
➜ Google Sheets Tip #288: Custom Split Text To Columns
In this tip, we look at how to use the Split Text To Columns custom option to perform unusual splits with your data.
For example, suppose we have a dataset like this and we want to separate the step numbers and the tasks:
Highlight the 10 steps and then go to the menu: Data > Split text to columns
In the Split text to columns menu, select custom:
Enter the custom rule, in this case, a colon followed by a space ": " to separate the text:
And there we have it!
We've separated the steps from the tasks.
I often reach for the SPLIT function when doing tasks like this, but this is a good reminder that the Split text to columns feature is available and often much quicker to use.
_______
If you enjoyed this newsletter, please forward it to a friend who might enjoy it.
Have a great week!
Cheers,
Ben
P.S. Nope, wrong iceberg!
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #341, your Monday morning espresso, in spreadsheet form! Hope you're out enjoying the beautiful Spring weather 🌱🌼 if you're in the Northern Hemisphere. And Fall if you're down south! ➜ News I.In case you missed it earlier in the month, I've now put the replay from the live Lambda Functions website on YouTube. Watch "Unlocking the Secrets of Lambda Functions" and grab the template for free here: II.My friend, and fellow...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #340, your Monday morning espresso, in spreadsheet form! I was reminded this week of the power of consistency. In January, I set a goal in Strava to ride my bike 3 times a week. Nothing crazy, but it's what I can realistically fit in with current work and family commitments. Aside from a few weeks of sickness and snow in January, I've done a pretty good job at sticking to it. And yesterday, I could notice a difference....
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #339, your Monday morning espresso, in spreadsheet form! I have a favor to ask. If you enjoy this newsletter, or my courses, videos or membership, will you help me improve them? It's been a while since I've run a full audience survey, and I'd love to get some fresh insight into any challenges you have using Sheets, how you use AI, how I can help, etc. Can you spare a few minutes to fill out my 2025 audience survey?...