How To Switch First and Last Name in Excel Column - Swap Last and First Name in Excel
HTML-код
- Опубликовано: 7 фев 2025
- 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.z6rj...
✦ 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.co...
💻 PresenterMedia: shareasale.com...
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/l...
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.... 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/6a0... 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.sharonsmit... 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
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
FANTASTIC Video - I watched a few others before finding yours and WOW, what a difference! You explained this so well. Thank you very much!
Oh - thank you so much! I'm so glad to hear that. I'm glad you found my videos helpful. Thanks so much for watching and taking time to leave such a nice comment. I really appreciate it!
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!
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!
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!
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!
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!
Thankyou for the help! Saved so much time and the video is apt!😊😊
LIFE SAVER. Thank you Sharon!
Glad to help! 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 so much. Saved our team a lot of work!
That is great to hear, Latasha! Glad you all found it helpful! Thanks for watching!
Today again i came back after last month and again this video helped. I tend to forget it because its a monthly activity for me, but thank you for being my saviour ❤
So glad you can revisit this video and find it helpful! Thanks so much for watching!
@SharonSmith ❤️
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!
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!
THANK YOU SO MUCH MA"AM, I SAVED YOUR VIDEO, very useful
You're welcome! I'm so glad it was helpful.
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!
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 was exactly want I wanted to learn. Thank you Sharon Smith
Great to hear, Tammy! Thanks for watching!
THANK YOU! IVE LEARNED SOME THING AGAIN.
Glad to hear it. Thanks for watching!
Very nice explained Sharon thank you. I have 36 players golfing on Mondays I created an excel workbook were does all the calculation for the type of prizes but there's a sheet where i set up the schedule for every week, for the first 5 weeks no one meets with anyone played previously but the last 4 weeks some players meet once or twice with a player that played previously I wondering if there is a formula to get through 9 weeks without meet. it would be greatly appreciated if you even could create a video for this instances. Thanks in advance
Love you, for this!!!! Thank you!
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!
Thank you! Very simple and very helpful
Glad you found it helpful! Thanks for watching!
Great video, thank you
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!
Would you know how to separate if the original text is an output of a formula or data feed? Is there a formula for this or would I need to initially split it into separate first name and last name columns?
Awesome! Thanks for the help
Glad to help! Thanks 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!
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!
This is so helpful!
Glad you found it helpful ;-) Thanks for watching!
Thank you for this tutorial!
Glad you found it helpful! Thanks for watching!
Life saver. Thanks
I'm happy to help! Thanks so much for watching my videos!
This is so clear and helpful. Thank you.
Glad you found it helpful!! Thanks for watching my videos!
Thank you!!
Glad to help! Thanks for watching!
Lovely ❤ thanks so much for the help ma'am ❤
Glad to help! Thanks for watching!
Thanks so much!
Thank you for watching!
Informative...very helpful my work
Glad you found it helpful! Thanks for watching!
It helps me a lot
Glad to help! 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!
thank you
Glad you found it helpful! Thanks for watching!
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!!!
very helpful
Glad you found it helpful, Jack! Thanks for watching!
Thank you so much
You are very welcome! I appreciate you watching my videos.
tHANK YOU
You are very welcome! Thanks for watching!
Thank you, but how do you insert the coma to separate the first and last name?
Add the coma between the two quotes.
Can I create a first last name column from a last first list no comma column?
Very useful
Glad you found it helpful! Thanks for watching!
Thank you🙏
You are very welcome!! Thanks for watching!
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?
If we have a last name, first name and some initials, middle names or none, how can we convert the names to be first name initial and last name?
To convert a name from "Last Name, First Name [Middle Names/Initials]" into "First Name Initial and Last Name" in Excel, you can use formulas to extract and rearrange the necessary components. Here’s a formula you can try:
=MID(A1,FIND(",",A1)+2,1) & ". " & LEFT(A1,FIND(",",A1)-1)
Output Example:
Input (A1): Doe, John A.
Output (Formula): J. Doe
I hope this helps! Thanks for watching!
Thanks
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!
I copied about 25 names from my word document to Excell. How do I make the row into a column. Transpose is not working. All names are in one cell.
Hello! Thank you for your question! It sounds like when you copied the names from Word into Excel, they all ended up in one cell. To fix this and get the names into individual cells, you can follow these steps:
Text to Columns:
First, select the cell with all the names.
Go to the Data tab, then click on Text to Columns.
Choose Delimited and click Next.
In the next window, select the delimiter that separates the names (such as Space or Comma, depending on how the names are separated in the text).
Click Finish, and Excel will split the names into separate columns.
Transposing to Rows:
Once the names are in separate cells, you can then copy the range of cells.
Right-click where you want the names to go (in rows, for example), and choose Paste Special > Transpose.
I hope this helps! Thanks for watching!
@@SharonSmith I'll give it a try. Thanks for the reply
Nice
Thanks for watching!!
How do you add the comma after you've switched it over
You'd replace the " " with a , so =(cell)&,&(cell)
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!
But some persons has a Middle name and also some Last name is Mc Donald how do we address those?
good stuff but you noticed there is a single space before the first name
Thank you so very much!
You are very welcome! Thanks for watching!
very helpful
Glad to help! Thanks for watching!
Thanks
Thanks for watching, Ramesh!