AutoSave Off Text manipulation_Final HOA (1) (version 1) Auto Recovered - Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Pivot Comments Share Calibri 11 ' ' Insert x General Paste BIU v v A v $ v % 500 Cell Conditional Format as Formatting Table Styles Delete Font > Alignment Number Styles Format Cells Sort & Find & Filter Select Analyze Data Editing Analysis Undo Clipboard 119 X fx Z A B C FRANK BAILEY FR 2 FRANK BAILEY 3 RENA BERKOWICZ 4 HEATHER BOND 5 JEFF BOROW 6 ZEV BOROW 7 ARIEL BOROW 8 LARRY BRAGG 9 HARRY BUNTING 10 JEFF COTTRELL D E F G H FRANK, BAILEY frank, bailey Frank Bailey F. Bailey 11 12 13 Above is a list of names that need to be reformatted. To the right (blue box) is an assortment of text- 14 manipulation functions you MUST use to mimic the appearance of the specimens (row 2). J frank.bailey@ourcompany.com frank.bailey@gmail.com 15 16 17 Try to figure out which functions from the functions list are needed to reformat the names, starting with Rena Berkowicz. 18 19 Z 20 HINT: Some functions may not be needed while some functions may be needed more than once. Functions 21 22 23 24 25 L Concat-enate M N Proper Left Upper Substitute Right Lower Text to Columns