Switch / Reverse First and Last Names In Excel With or Without a Comma

In this video I show you how to reverse first and last names in Excel. There are two methods you can employ

1) Use Flash Fill. This is a very quick.
2) Use text functions: SEARCH, MID, LEFT. This formula is more involved and you would only use it if you wanted to link you switched names to the original.
------------------------

[leahms]

By far the easiest tutorial I've found to reverse names. Thank you for going at a pace that allowed me to follow without having to pause to many times.

[DWhite]

I have searched high and low for ALL kinds of tutorials. THIS was the most simplistic and easiest way to do this! Keep them coming!

[kierangoldsworthy]

I have never been this surprised by an excel tutorial, thank you for the quickest and easiest one I have seen!

[Jacteaux]

THANK YOU! Simple and easy to understand. Thank you for not droning on with details we don't need.

[beth]

This just SAVED me! I've been looking everywhere on how to do this. Thank you so much!

[QuinctiliusVarus]

Finally! By far the best tutorial on any subject.

[MzPerez]

You just saved me over. 20 min of work! Thank you for your help, great tutorial.

[kmiddlebrooks]

Best and most efficient way ever! Shared with all my coworkers and friends! Thank you, Chester!

[countduckula]

Hi Chester,
Wonderful tutorial video!
Two useful ways to reverse names; I liked how you explained the normally complicated formula part by breaking it down into easy to follow stages.

[LourdVicious]

Such a life saver. Saved hours of work!

[richarddestefano]

So helpful!! You just saved me hours of work!!
Thank you

[theplinkerslodge]

Thanks, downloaded your example file and was able to reverse-engineer it to separate reverse order names that were separated by a comma

[julieanneorcajada]

Finaly I found the solution for my problem. Thank you so much! :) Its very useful

[IvanCortinas_ES]

Excellent proposal. We could also do it with Power Query. Thank you very much Chester.

[soulfight]

Thank you, my good sir! Very helpful and easy

[wayneedmondson]

Thanks Chester! Both useful ways to accomplish the task. Could also be done easily in Power Query. Thumbs up!!

[johnenglish]

Absolutely awesome and simple! Thanks!

[carlossavan]

🤝👏👏bravo i've been searching for this kind of problem im facing now i found... thanks 🤗

[farb]

I got it, I just put a ", " instead of " ". Thank you!!

[farb]

found it. same thing, just place a ", " instead of " " on the first search, thank you again