Excel Magic Trick 292 Reverse

Media Summary: See how to Extract First and Last Names and rearrange them using a formula. For example, go from Smitty, Sioux Z. to Sioux Z. (17:26) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book 8. (17:38) Summary Related Videos:

Excel Magic Trick 292 Reverse - Detailed Analysis & Overview

See how to Extract First and Last Names and rearrange them using a formula. For example, go from Smitty, Sioux Z. to Sioux Z. (17:26) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book 8. (17:38) Summary Related Videos:

Photo Gallery

Excel Magic Trick 292: Reverse Last & First Name Tricks

Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Excel Magic Trick #182: Workbook References

Excel Magic Trick #117: Reverse 2-Way Lookup Part 1

Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates

Excel Magic Trick #118: Reverse 2-Way Lookup Part 2

Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?

Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID

Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 167p1 IF function formula: 12 Examples!

View Detailed Profile

Excel Magic Trick 292: Reverse Last & First Name Tricks

Excel Magic Trick 292: Reverse Last & First Name Tricks

See how to Extract First and Last Names and rearrange them using a formula. For example, go from Smitty, Sioux Z. to Sioux Z.

Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table

Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table

Download

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Download

Excel Magic Trick #182: Workbook References

Excel Magic Trick #182: Workbook References

Download

Excel Magic Trick #117: Reverse 2-Way Lookup Part 1

Excel Magic Trick #117: Reverse 2-Way Lookup Part 1

Download

Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates

Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates

Download

Excel Magic Trick #118: Reverse 2-Way Lookup Part 2

Excel Magic Trick #118: Reverse 2-Way Lookup Part 2

Download

Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?

Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?

(17:26) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book 8. (17:38) Summary Related Videos:

Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID

Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID

Download

Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions

Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions

Download

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Download

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel If statement

Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates

Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates

Download