This is an age old question, but I'd love to source some wisdom from this community. Last week, I had two medium-sized data migrations that required a TON of cleaning/deduping Org/Account records because of insignificant spelling differences, including (or not) "The [blah blah]" or "[Blah} Inc." Besides deduping, sorting alphabetically, eyeballing, and using Excel text formulas, does anyone have good ideas for how to do it? One of my use cases is Schools/Districts (notoriously difficult), but the other one is just run of the mill. Thanks!
