top of page
  • Writer's pictureBoban Nišavić

Leader to Follow on LinkedIn - Lucas Perret on his Normalizing Company Names in Your Prospect Lists


"The easiest way to be seen as a spammer ↓


Not mentioning your prospect's company name correctly.


"Hey, how are things going at Google® llc.?" ❌❌❌


The problem?


Too many people are still doing this.


Because when scraping data, the {companyName} may include:


・legal entity abbreviations - LLC, Inc., Pvt Ltd…

・emojis and special characters

・unnecessary context - "we are hiring 🚀"…


Here’s how you can fix it before importing to your prospecting tool:


STEP 1: Go to Google Sheet and add your list


STEP 2: Use the following formula:


=trim(regexreplace(regexreplace(REGEXREPLACE(REGEXREPLACE(split(split(split(split(SPLIT( {companyName}," | ",false,)," (",false,)," - ",false,),": ",false,),", ",false,),"\.(\s|$)"," "),"(?i)\sINC(\s|$)|\sLLC(\s|$)|\sLLP(\s|$)|\sINCORPORATED(\s|$)|LIMITED LIABILITY COMPANY|ltd|\sCORP(\s|$)"," "),"[^A-Za-zÀ-ÖØ-öø-ÿ;\s;-;0-9;’;\.;\-;\+;\!;\?;\']",""),"(?i)\sPVT(\s|$)|\sPTY(\s|$)"," "))


STEP 3: Replace {companyName} with the cell you need to normalize


STEP 4: Drag the formula down


…and enjoy a much cleaner list!


Thanks Victor for the post idea 💡"


6 views0 comments

Kommentare


Post: Blog2_Post
bottom of page