⭐ 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

ChatGPT Images 2.0 | Graphic Design and Product Photography
655 views

Claude Design and Claude Code | Idea to iOS App in 30min
1.3K views

How to Create and Use Chat Branches in Claude 1
954 views

New Claude Opus 4.7 — better memory, better instructions, same usage limits problem
1.3K views

Logitech MX Series Review - How I’m Using All of Them
224 views

Epomaker Galaxy 100 Vs Logitech Mx Keys S Review
179 views