Reverse First and Last Names in Excel
HTML-код
- Опубликовано: 23 июл 2024
- www.contextures.com/excelsplit... Visit this page to download the sample file for this video.
Use a formula in Excel to reverse the order of names in a cell. Change from Last Name, First Name to First Name Last Name.
00:00 Introduction
00:18 View the Formula
00:40 Find the Comma
01:13 Formula for Comma
02:34 Get the Last Name Length
03:01 Get the Last Name
03:43 Add a Space
04:25 Begin the First Name Formula
05:52 How to Calculate Length of First Name
06:41 Formula for First Name Length
07:03 Get Space Position
07:27 Length of First Name
08:05 Review the Formula
08:42 Get the Sample File
Watch this video to see how to create the formula to pull the first name and last names from a list of names, and put a space character between them. Наука
Bravo for the step by step explanation.
You make it very easy for everyone 😉
Thank you 😊
You're welcome, and thanks for your kind words about the video - I appreciate it!
Thanks for the cool tip!
This was so cool to watch and see how extensive formulas work! - It worked great for me up until the last step, then nothing I did would make it successfully work. Thanks for helping me better understand how formulas can be put together though!
This was the helpful instruction/explanation I've seen of this function. Thank you!
Thank you, Rebecca!
Hugely helpful. Quick and to the point. Thanks
excellent excel video as always!!!!!
Many thanks, really useful!
Thanks Debra. Great use and explanation of right, left, search, and Len.
Just... no.
IF NAME in A2 is LAST, FIRST
IN B2 put: =MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2)-1)
Now copy and paste to other cells below.
Great thanks works a charm much simpler but with that said still wanted to thank the lady. So thanks to you both.
THANKS SCOTT FOR THE FORMULA
Not all heroes wear capes. Thanks for the formula!
Awesome! Tnx!
What about this one? (ACTUAL name changed to preserve privacy)
I used this formula and it worked for all of them except this one
Foster-Cea Nilo, Valarie Edna ---> Nilo, Valarie Edna Foster-Ce
Great video.
Thank you!
THANKS, VIRAL VIDEO!
You're welcome! Thanks for your comment!
Great video! Can a IF formula be used, if the data is mixed up with both 1st name followed by last name and last name followed by 1st name- all I want in data is to change Last name followed by First name to First name followed by last? Can you please advise the formula? Thanks!!
Thanks, and you could use IFERROR to return the existing name, if there's no comma in the cell:
=IFERROR(original_formula,A2)
Great video, good formula
Thanx to Microsoft Office 2013 this can be done much easier using Flash Fill
Laza Lazarevic Yes, Flash Fill is a great tool for a quick fix! This formula is useful if more names will be added, and you want those names reversed automatically.
Contextures Inc. I totally agree
thanx
Thank you so much, I was able to flip date format. With this formula, I added the MID and it worked :)
=RIGHT(G5,4)&"/"&MID(G5,4,2)&"/"&LEFT(G5,SEARCH("/",G5,1)-1)
How can I do the opposite? Make Mary Smith turn into Smith, Mary. This would save me so much time! Please help!
Thanks, and I show how to do that in this video:
ruclips.net/video/P6NDbViRQW4/видео.html
What if names and surnames are mixed up?
I want to do the exact opposite of what you just demonstrated ?
Me too
How to reverse first name to last separated by comma like change this name Firmalino Chandra Young to Young, Firmalino C.
Or Donald Trump to Trump, Donald