6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

Warriors someones gotta have an idea

by barry500
5 replies
Warriors

I have lists of senior contacts in various markets in excel
first name, last name, website, tel no etc....
I am trying to find a method of turning this data into a list of complete email addresses without manually typing firstnamedotlastname@domainname for every record

Ideally I would also like to be able to ping/verify each email to ensure accuracy. Any ideas ? Be a great help if someone had a way of tackling this or knew an outsourcer with some knowledge.
#gotta #idea #someones #warriors
  • Profile picture of the author rusty1027
    you can automatically generate the list using excels built in string functions pretty easily - here is an example of how to join 3 cells to make an email address as you described...

    =(B2&"."&C2&"@"&D2)
    {{ DiscussionBoard.errors[4223692].message }}
  • Profile picture of the author barry500
    Rusty

    cannot get that to fly - but no doubt an issue my side !! Would this really generate the first do last dot domain as full email in another column? Bit flummoxed.
    Signature

    {{ DiscussionBoard.errors[4223741].message }}
  • Profile picture of the author rusty1027
    what version of Excel do you have? I'll send you a sample file
    {{ DiscussionBoard.errors[4223756].message }}
    • Profile picture of the author barry500
      Rusty

      over and above the call...thanks so much for taking the time to give your advice.

      Barry
      Signature

      {{ DiscussionBoard.errors[4223867].message }}
      • Profile picture of the author RonnyRaygun
        In newer versions of excel I use a function called 'concatenate()'

        So something along the lines of: =concatenate(A1,".",B1,"@",C1)
        Signature

        {{ DiscussionBoard.errors[4223973].message }}

Trending Topics