Clay Icon
Join the Community
02 Support

Any formula to clean company name? I tried the one in Clay but only fi...

Avatar of Cody C.Cody C.
·
·

Any formula to clean company name? I tried the one in Clay but only fixed a few LLCs etc

4 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Cody, appreciate your patience! We do have the Normalize company name integration but it may miss a few, so will have to check/update for some improvements. For those edge cases that still come through, I would use a conditional formula to further remove each of those values like "LLC", "inc", etc.... Other than that, I've seen a few people use chatGPT for better accuracy

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hope this helps in the meantime!