|
Featured Tutorial
Featured Macro
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
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm