Excel Forum
Similar Content
Send Emails through Outlook using Email Addresses from Excel and text from Word
Macro: This macro allows you to send an email to a list of recipients through excel. The email wi...

Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail

Take bad data set up in one column and make a proper table of data for mail merge. See how to extract name and e-mail data from a list in one column where records are entered inconsistently. See the INDEX, SMALL, ROW, ROWS, COUNTIF, SEARCH, INSNUMBER and IF functions in a 2 formulas and 2 array formulas.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.