Excel Forum

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.