How To Switch First and Last Name in Excel Column - Swap Last and First Name in Excel
HTML-код
- Опубликовано: 16 ноя 2021
- 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
🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
✦ Screen Recording Software: techsmith.z6rjha.net/NZG5b
✦ Green Screen: amzn.to/2DnHsY2
✦ Camera: amzn.to/39KvpQA
✦ Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
✏️ JotForm: www.jotform.com/pricing/?utm_...
💻 PresenterMedia: shareasale.com/r.cfm?b=417324...
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
Check out my helpful list of templates available for purchase: www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
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:
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist
This is a fantastic video that saved me about 4 hours of work and a ton of error avoided! You ROCK!
Awesome! That is great to hear. Thanks for watching!
You just saved me hours of work! Easy to follow and very helpful. Thank you!!!
Awesome! Glad to hear that! Thanks for watching my videos, Kyle!
Awesome video, Sharon. This helps so much. Especially when exporting data from ADP!
Great to hear! Let me know if you have any other "data cleaning" issues when exporting your HR/Payroll data from ADP. I'm slways looking for ideas for more videos that folks will find useful. Thanks for watching!
Thank you so much. Saved our team a lot of work!
That is great to hear, Latasha! Glad you all found it helpful! Thanks for watching!
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.
That is great to hear! I’m glad you find my videos helpful! Thanks for watching!
This was exactly want I wanted to learn. Thank you Sharon Smith
Great to hear, Tammy! Thanks for watching!
OMG THIS HAS SAVED SOOOOO MUCH TIME FOR ME!!!! THANK YOU! (yes all caps because I am super excited)
I'm so glad that my video helped you!!! Thanks for watching!
This is so clear and helpful. Thank you.
Glad you found it helpful!! Thanks for watching my videos!
Thank you! Very simple and very helpful
Glad you found it helpful! Thanks for watching!
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!
Glad to hear my video helped you out! Thanks for watching!
Awesome! Thanks for the help
Glad to help! Thanks for watching!
This serious just saved me about an hour worth or work! Thank you.
So glad to hear you found it helpful and it saved you time! Thanks for watching!
This is so helpful!
Glad you found it helpful ;-) Thanks for watching!
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!
Thank you so much! I'm glad you got something new out of this video. I really appreciate your support and I'm glad you found my channel!
Thank you so much for the donation to my Channel! It is greatly appreciated!
Thank you for this tutorial!
Glad you found it helpful! Thanks for watching!
Thank you - been looking for this fr 20 mins! :)
Glad you found my video! Thanks for watching!
Excellent Presentation. For someone who has no eperience in Excel you made very easy.
I'm so glad to hear that! I hope you are learning a lot from my videos. Thanks for watching!
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😭
I’m so glad to hear my video helped save you valuable time! Thanks for talking time to leave a nice comment. I appreciate it!
a fantastic instructional video, just saved me a ton of grief and frustration!
So glad to hear it! Thanks for watching and for subscribing to my Channel!
Thanks so much!
Thank you for watching!
Life saver. Thanks
I'm happy to help! Thanks so much for watching my videos!
Informative...very helpful my work
Glad you found it helpful! Thanks for watching!
You just saved my butt at work thank you so much,
Awesome! Glad to hear my video helped you out at work. Thanks so much for watching!
excellent saved me soooo much time
So glad you found my videos helpful, Victoria! Thanks for watching and for subscribing to my Channel!
Thank you so much
You are very welcome! I appreciate you watching my videos.
It helps me a lot
Glad to help! Thanks for watching!
Thank you🙏
You are very welcome!! Thanks for watching!
very helpful
Glad to help! Thanks for watching!
Very useful
Glad you found it helpful! Thanks for watching!
Your video saved me from my perfectionist friend hahaha thank you so much
Haha! Glad to help! Thanks for watching!
Thanks
Thanks for watching, Ramesh!
Thank You
You are very welcome! Thanks for watching!
how do you make this a "running" function? you copied and pasted the names, but what if you regularly add names to the list, and want this function to happen as you add the names?
tHANK YOU
You are very welcome! Thanks for watching!
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
Hello, assuming your formatting has a space between first and other names in the cell, you can use the Text to Columns feature to extract the first name into a different column/cell.
1. Select the column that contains the full names and insert a new blank column next to it.
2. Go to the Data tab in the Excel ribbon.
3. Click on Text to Columns in the Data Tools group.
4. In the Convert Text to Columns Wizard, select Delimited and click Next.
5. Check the box next to Space and uncheck all other boxes. You should see a preview of how the text will be separated in the Data preview section. Click Next.
6. In the third step of the wizard, you can specify the data format for each column if needed. For this case, you can leave everything as General and click Finish.
You should now have two new columns: one with the first names and another with the rest of the names.
Hope this helps! Thanks for watching my videos!
Can I create a first last name column from a last first list no comma column?
Thank you, but how do you insert the coma to separate the first and last name?
Add the coma between the two quotes.
How do you add the comma after you've switched it over
Thank you Sharon for this video. I do have a question, whenever I do this instead of having a single space between the first and last name, it always ends up being around 30 spaces between the names. Anyone know why this is happening and how to correct? Thanks.
I'm not sure why that is happening, but if you have a cell formatted with text and too many spaces between first and last name, you can insert a new blank column next to the name column and use the TRIM formula. Click in a cell and type: =TRIM(A2) if A2 were the cell that had the name with too many spaces. TRIM will eliminate all the extra spaces. Hope this helps! Thanks for watching!
@@SharonSmith THAT WORKED!!! THANK YOU!!!
Nice
Thanks for watching!!
What if I have a list that has John & Jane Doe or John Doe & Jane Doe. Is there a way to do that?
Can you clarify what you are trying to do? You can create text manipulation functions in Excel to handle this. Are you trying to update John & Jane Doe to "Doe, John & Jane?" or split them out? Thanks for watching!
You need to also check off the space with the comma when selecting your delimiter, otherwise you end up with a space in front of the name, as she did in this example.
😀
Now there is a space in front of the first name. How do I get rid of that?
Hi Ryan! Select the column in your spreadsheet that has the space+name. On the Home tab, in the Editing area, drop-down "Find & Select" and select "Replace." This opens the Find & Replace pop-up window where you can select the "Replace" tab, and in the field for "Find what:" place your cursor there and hit one space. Leave the "Replace with:" field blank and then click "Replace All." This will remove that space in the column or cell you selected. Hope this helps! Thanks for watching!
good stuff but you noticed there is a single space before the first name
very helpful
Glad you found it helpful, Jack! Thanks for watching!
Thanks
Thanks for watching!!