If you're still typing long, comma-heavy CONCATENATE formulas to merge text in Excel, you're doing more manual work than necessary. Since switching to four alternatives that make combining data faster ...

I used to rely on Excel's Remove Duplicates tool like a reflex, but it's actually a dangerous, destructive, dead-end process that leaves no visible audit trail. So, I've switched to the UNIQUE ...