Excel Forum
Similar Content
Send Emails through Outlook using Email Addresses from Excel and text from Word
Macro: Send Emails from Excel Course This macro allows you to send an email to a list of recipien...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.