<aside> 💡 Use this as a method to clean company names without losing chunks of text due to bad google sheets formulas

</aside>

Note: This method isn’t great on large lead lists - break down in blocks of 100

Video Tutorial:

https://www.loom.com/share/6b91e1f6b4d04c8981a4ac505ff17c56

Prompt:

Format the following business names correctly and remove all suffixes and put each company name on a separate line with a comma after each one: