Separate First and Last Names

[@mgportraits]

OMG, you are amazing! i been looking all over to learn how to do this. Thank you so much!

[@DougHExcel]

Hi mgportraits, glad you liked it, thanks for commenting!

[@uhngry01]

Thank you - that was so helpful!

[@DougHExcel]

Glad it was helpful!

[@Paper_Trader]

Well now we have =TEXTSPLIT replacing LeftMidRight formula
Add on : Xlookup instead of Vlookup and IndexMatch

[@Balsero-qb9gv]

Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith
Thank you so much!!

[@DougHExcel]

in the text to column window (Step 2) use the other field option to enter the dash

[@cooljenify]

So easy, Thanks for the lesson.

[@DougHExcel]

Glad you liked!

[@TheWahed786]

Good one.
Interesting.
Enjoyed.

[@latriciawilson5176]

Thanks so much, this helped me with a document for work!

[@DougHExcel]

Hi Latricia Wilson, thanks for the comment!

[@EMISOPL2010]

What if first names and last names are mixed up?

[@DougHExcel]

oh boy...then that'll have to manually cleaned up

[@EMISOPL2010]

Hihihi, I am a woman. I thought so, thanks.

[@EMISOPL2010]

I thought so. I have to do it manually. Thanks for answer, Christina.

[@iamwhat23]

Now we have flash fill 😁

[@DougHExcel]

Hi Shark Bait, thanks for the comment!