Main Profile

At A Glance

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
Length: 12:12

Contact

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

Want more info about Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question