How to Properly Format Company Names In Spreadsheet From .CSV (At Scale)?
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! @Christian Bonnier @Christian Bonnier @Andre Haykal Jr