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

Thank you Mike for the great explanation.

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

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

Could we use find instead of serch here??

Dont buy Adam Hudson stuff.
My mate spent $3000 and said it was a scam.
Apparently they didnt deliver what they promise i. These ads.

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

Beautiful text formula :)

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

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

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

Amazing tricks, thanks Mike!

Flash fill is best trick

Nice new bonus way
Thanks Mike

Hard to beat "old school" text formulas!!

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

Thanks Mike

Thanks Mike

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

Perfect

Yaaaaay!!! Thank you Mike!!!

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

Fantabulous!!!

Mike sir rocks in excel

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?

Nice formulas ... power query is the best!

That was awesome Mike, thank you!

=STXT(B3;TROUVE(",";B3)+1;100)&" "&STXT(B3;1;TROUVE(",";B3)-1)

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?

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:
=TRIM(MID([@Name],SEARCH(" ",[@Name])+1,LEN([@Name]))) & " " & LEFT([@Name],SEARCH(",",[@Name])-1)
..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!

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

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

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

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.

super like