In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods are still valid in Excel 2013, but the combined data ...
Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results