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 #369, your Monday morning espresso, in spreadsheet form! We had our first snowfall of the season last Friday, so winter is definitely underway here in the Mid-Atlantic region. It was only a light dusting though, so the sleds are still hanging in the garage. For now. In this issue, we're looking at a clever way to add visual clues to our data tables with indicator arrows ▲🔻. And, if you're a Workspace customer, you must...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #368, your Monday morning espresso, in spreadsheet form! I finished reading a fascinating book last week, Home on the Canal, a long-out-of-print history of the Chesapeake and Ohio Canal and the stories of the people who lived and worked along it. Today, I live beside the canal, now a beautiful National Historic Park, and cycle or walk on the restored towpath most weeks. Riding across the Antietam Aqueduct recently, I...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #367, your Monday morning espresso, in spreadsheet form! For my birthday this year, my wife bought me a half-day fly fishing lesson. I had previously tried casting with a fly rod a few years ago in Wyoming, and have been keen to have another go ever since. As a middle-aged dad, my life is, well... maybe a little... predictable. In a good way. Family, work, exercise outdoors, eat, sleep, and repeat. It's a wonderful,...