Easily Split Data in a Spreadsheet Cell

⭐ Get good at spreadsheets: https://gotsheet.xyz/c/gotsheet-youtube Walkthrough of using SPLIT to clean up dirty data in a Google Sheet. This'll work in Excel too, the formula is just named differently there: TEXTSPLIT() 🎬 Watch next: https://youtu.be/XCNT3s7o5tM ──────────────────── 💰 Deals & Tools • Convert PDFs and images to Excel - https://lido.app/link/eamonn • Connect Google Sheets or Excel directly to your business systems like CRMs, databases, and APIs - https://coefficient.io/?via=eamonn • 20% off Beehiiv (3 mo.): https://beehiiv.com/partners/got-sheet?via=eamonn • My full tech stack: https://gotsheet.xyz/c/business-tech-stack • My recommended gear: https://amzn.to/4l47CyW *Disclosure: affiliate links may earn me a small commission at no cost to you.* ──────────────────── ⌚ Timestamps: 00:00:00 - dirty data 00:01:16 - split by blank lines 00:03:09 - split by specific characters 00:03:40 - split by each 00:05:04 - dummy check 00:06:30 - control trick ──────────────────── 🌐 Site: https://eamonncottrell.com 📇 LinkedIn: https://linkedin.com/in/eamonncottrell 🐦 X/Twitter: https://twitter.com/EamonnCottrell