I have a question, regarding proper formatting of company names at scale.
It seems with every LK export, the .csv has used a formula to take abbreviated company names from the URL.
But we need proper formatting of company names, not to be
- Trwcreditgroup, but TRW Credit Group
- Dixiecupfcu, but Dixie Cup FCU (or Federal Credit Union)
... for example.
Does anyone know how to update these properly at scale, with lists of 5,000+ for example? As doing that manually is an insanely arduous amount of work.
I've tried ChatGPT, Google Sheets Apps/Code, and formulas - and none of those seem to do what I need here.
Any help is greatly appreciated, as I'm doing this for my own lists, and on behalf of clients.
Thank you!