Excel Formula to Reverse First & Last Name. Better Than Power Query & Flash Fill? - EMT 1581

Learn how to use a formula to Extract First & Last Name with Excel Formula from Last, First. Learn how a formula can be better than Flash Fill or Power Query. Learn about the Excel Worksheet Formulas: REPLACE, SEARCH, LEFT, LEN and RIGHT.
Related video:
Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data

[simoiyahector-morales]

I get goosebumps EVERY time these vids are uploaded, excellent excel tips and tricks

[lazalazarevic]

Great Mike. Love this new approach of having short videos and link to the more detailed ones. Love your work

[katerina]

Absolutely fantastic, this excel fun is endless. Thank you Mike 🤗

[anthonyverdin]

Thank you Mike for the great explanation.

[wayneedmondson]

Hi Mike.. love that REPLACE method.. didn't think of that one. Here is my first pass using TRIM, MID, SEARCH, LEN and LEFT.. same result:
..more similar to your bonus formula logic using RIGHT, LEN, SEARCH and LEFT. Excel is fun when you can come up with multiple ways to produce a solution : )) Thanks and Thumbs up!

[johnborg]

Thanks mike. I would have gone for the bonus formula like Geert commented below.

[JanBolhuis]

Thank you. The bonus formula is great when you have to deal with prefixes which can differ per person.

[romanguz]

That is such a common problem in my HR department for data transformation. Thank you for sharing!

[GeertDelmulle]

The bonus formula is how I would have done it in the first place.
BTW: why not search for “, “ (comma space), that way (first) names with spaces in them will work, too.
Just searching for a single space is risky...
...but better than flash fill?... I like that feature, too, although it’s more of a one time deal.

[sathyanarayanansatagopan]

Sir, please make a video comprising complete guidance for XML & TDL creation on our own for export purpose

[richardhay]

Hard to beat "old school" text formulas!!

[reappraiser]

I am looking for a formula that will give me the last name and suffix, from the full name in a single cell. Example,  Name" John W Smith III, Result Desired: Smith III, would like it to work with and without a middle initial. Thanks

[bigE]

Great video! What is the difference or advantage of REPLACE instead of SUBSTITUTE?

Also instead of using the RIGHT function I use MID & SEARCH then for the number of characters argument I put in a higher number than I would ever need. Is there anything wrong with doing it this way as far as how the functions are programmed to work?

[jmbarnedo]

How about for two first name and two last name. e.g. Dela Cruz, Mary Jane :)

[mohamedchakroun]

Could we use find instead of serch here??

[NoShadowOfDoubt]

Nice formulas ... power query is the best!

[sulaimanalsuhaimi]

Your channel seems to be a good place to learn Excel! But I don't know where to start! Is there a playlist that I should start with?

[DIGITAL_COOKING]

Techniques for three minutes and a half can save hours of works, it is sad to know that I'm struggling to convince young business students to put some time some efforts (like this one, not more than 4 minutes!!!!) To study excel

[cesarosorio]

The formula does not work correctly with compound names or surnames : (

[rguy]

This formula breaks down if you have names like  "Smith, Peggy Sue", so it's more robust to search for ", ".