In Part’s 1 and 2 of this Excel series we covered how to manipulate your list of names by either combining or separating the columns. Let’s take that one step further now in the coolest hack of all, automatic email address creation. Through the use of Excel formulas you can take a list of names plus a company email syntax and generate a list of corporate email address. When I finally constructed the correct formulas for each of these I felt that I had hit the jackpot.
Sourcer Tip for Excel #3 – Email Address Creation
Where can this tip come in handy? When you’ve spent time on name generation or org charting of a target company (we’ll call it Company A) and have developed a list of employees whom you’d like to contact. You have also discovered the email syntax that Company A uses. Using the tips taught in Part 2 you can separate out the first and last names in an effort to quickly create a complete list of email address. How? Through the use of one of the following formulas.