Excel at this

Excel at this: Say you’re using Microsoft Excel, and you have a list of employees’ names in column A (e.g., John Doe, Jane Smith and Emily Jones), but you need to give them standard email addresses in column B. In column B, next to their name in column A, type the corresponding email address — think “jdoe@company.com” for the “John Doe” in column A. Now, the magic: Click on the cell where you typed the email address, and then press Ctrl + E. Excel will automatically “flash fill” the column with email addresses following your pattern.

Tags: addresses, company, email, email addresses, employees, Excel, Microsoft Excel, names