Convert “First Name Last Name” to “Last Name, First Name” in Excel (Solution #1)

This video provides a brief tutorial showing how to use Excel’s TEXT-TO-COLUMNS feature along with the CONCAT function to convert cells from a “First Name Last Name” format to a “Last Name, First Name” format. This strategy is Solution #1.

#FrankMLoSchiavo #ExcelAficionado

The Frank Show Starring Frank M. LoSchiavo features educational videos packed with lots of great information! Like an old-fashioned general store, my channel has something for everybody. Many of my videos feature lectures on statistics and psychology, but there are bonus videos on a variety of other topics, so subscribe today and join the fun!

SUPPORT MY CHANNEL: If you find my videos helpful, please like them, share them, and tell all your friends to check out my channel!

* CONSIDER A VENMO DONATION: @Frank-M-LoSchiavo

[CebastyanB]

Hello, I work for American Airlines as an Executive Assistant and I use Excel quite frequently however I'm a novice. Your video was so easy to understand and I've watched a million videos to help me through certain processes! Yours was the best I've seen thus far. Great Job and I really appreciate you - I'll be sharing your details with all my Admins as well!

[Elle_Gee]

Thank you - this is by far the easiest tutorial I have found. I rarely have to do it and have to search to figure out the answer - thanks for making my job easier today!

[igotjoy]

Thank you for such a clear explanation! Much appreciated!

[Drayafenandez]

Thank you! This was very helpful. I don't normally need to use Excel for work so you just saved me about an hour of time!!!

[tantelapin]

Brilliant! Just what I needed. Thanks.

[WilliamsonIns]

Super helpful! Thank you so much for this. 👍

[Mmaarrzz]

Thank you thank you ! I have no idea what I’m doing at my new job but I’m learning, from you ! Much appreciated

[jacquelinepasker]

This was so helpful - thank you! Nice and easy to follow along to.

[erikachubb]

Thank you so much. I read and tried everyone elses suggestions and they didn't work. Your video worked. Thank you so much. Im saving your video.

[CMGrant]

This video has been so helpful to me. Thank you!

[dandelacruz]

I got it, yay. You are a good teacher. God bless you, 🙏🏼.

[keithjones]

Thank you Frank. That's what I needed to know.

[EdTechSpokane]

That was exactly what I needed. Thanks

[Meggamuffin]

Just saved from having to redo an entire spread sheet! Thank you!!!

[rsmstudios]

OH MY GOSH!!! This is something that has frustrated me for YEARS!!! So many different Divisions inside our City Government list their employees in Excel as First Name, Last Name, others just first name or just last name, when all I really want is LAST NAME, FIRST NAME. Where have you been all my life? I "used to" consider myself very experienced in Excel. Well, today you proved me wrong. Thanks again!!!

[slwplace]

Yay! This was easy to follow and helped me with a huge list of names! But some people have 2, 3 or 4 middle names between first and last (all in the same cell). What do I do about that?! Thanks a million.

[debbieryckman]

Hello Frank. Your video was very helpful in finding a solution to name sorting. It did not work on the final step for me and I wonder if it is because I exported a csv file, not excel file. I need a csv file format because it needs to be uploaded to an accounting software program. What would be your suggestions in this case? I was able to split the first name and the last name into 2 columns, but then to use the contat function it didn't seem to work. Thank you.

[parladecreativeminds]

Great video! How would I use the =CONCAT to automatically add once a new name is added on a new row. I tried to use the drag box down extra blank rows but it fills in a comma and space.

Also I want to use that information to populate a drop down box in a form. Do you know how I'd be able to do that without those commas appearing.