How To Switch First and Last Name in Excel Column - Swap Last and First Name in Excel

REVERSE NAMES IN EXCEL // Learn how to create a First Name (space) Last Name column in Excel from a Last Name, (comma) First Name column. You will see how to use text to columns to split the last and first names and then use the & to re-combine the names in the desired format.
Other ways to describe this include: how to flip the first and last name in cells in Excel, reverse last name first name in excel with comma, and how to create first last name from last first name in Excel.
__________
RESOURCES & GEAR

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
__________
FREE DOWNLOADS:
__________
CONNECT WITH ME:
__________
KEYWORDS: #MSExcel, how to switch names in a cell in Excel, flip first and last names in Excel, reverse last name first name in Excel, how to split or reverse first last names in Excel, how to rearrange names in Excel, how to flip names in Excel with comma, how to change name format in Excel, how to revers first name and last name, Text to Columns in Excel, Combine function in Excel, Combine using & in Excel, Excel formulas for HR, Excel tips and tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:

[JimConnely]

This is a fantastic video that saved me about 4 hours of work and a ton of error avoided! You ROCK!

[Lakewood]

Thank you! You are a fantastic instructor. And I don't say that lightly. You are now my go-to source when I need help with Excel.

[xpofwis]

Excellent Presentation. For someone who has no eperience in Excel you made very easy.

[JHEMCALSE]

OMG, Thank you verrryyyy muuucchh. Your video really helped me. Just like Kyle said, You just saved me hours of work, cuz I've been recording scanned attendance of almost 500 students😭

[JaimeOliveros-xiio]

Very helpful video. I was wondering about changing the names to values as I ran into this problem before I finished watching the video. Thank you so much!

[NicoleScottMyBookFilledLife]

a fantastic instructional video, just saved me a ton of grief and frustration!

[jessicarosa]

OMG THIS HAS SAVED MUCH TIME FOR ME!!!! THANK YOU! (yes all caps because I am super excited)

[levimccoy]

This serious just saved me about an hour worth or work! Thank you.

[latashasund]

Thank you so much. Saved our team a lot of work!

[tammywong]

This was exactly want I wanted to learn. Thank you Sharon Smith

[kyles]

You just saved me hours of work! Easy to follow and very helpful. Thank you!!!

[Vigilant-Citizen]

Awesome video, Sharon. This helps so much. Especially when exporting data from ADP!

[Teacherman]

I viewed this video, even though I had learned how to do this previously, in order to refresh myself. Also after viewing other videos of yours I was curious as to how you would present this topic. My intial impressions were correct, your videos are among the much better ones available! I'm just surprised at the number of likes; I feel the number should be much, much higher! Also, you covered an aspect I didn't know, how to swap from full name with last name first to full name with first name first! Learn something new every day! Thanks for doing such an exemplary job and making such great video tutorials!

[frezzahajal]

Your video saved me from my perfectionist friend hahaha thank you so much

[xxcatsnacksxx]

You just saved my butt at work thank you so much,

[baselemla]

Thank you! Very simple and very helpful

[Lou-hubx]

Thank you - been looking for this fr 20 mins! :)

[donnaryan]

This is so clear and helpful. Thank you.

[ufit]

Thank you so much for sharing this. I have a question that I believe many others also have. From a column with the full name of first name 2 or 3 middle names and last name. How could you separate only the first name in one column and the rest of the name in another column? Thanks in advance for your time

[summer]

What if I have a list that has John & Jane Doe or John Doe & Jane Doe. Is there a way to do that?