Pull First, Middle and Last Names From One Cell Into Separate Cells In Excel 2010

What if there are more than 3 columns

37wu

this method is no good for names with 2 or more in the midddle

Thank you so much for this video, It was really helpful.

hello! So I have this string: <p> <strong>TP 80-110/4-A-F-A-BAQE 400D 50HZ</strong></p> <p> <strong>Cod produs: 96108837</strong></p>

I want to extract from this string only the number after "Cod produs", meaning 96108837. How can I do that? Thank you!

how about if we want the middel 2 digit

REALLY EXCELLENT STUFF... HAD BEEN SEARCHING FOR THIS FOR VERY LONG TIME !!

I have an excel list 900 numbers in one single cell. I want to put each number in its individual cell. How can I do that? Please advise.

KUMAR, VIJAY (BCA) (DU) TO CONVER VIJAY KUMAR . PLS SOLVE IT

How about with multiple first names and two last names example: Thorton Alton, John Levy Ion(first names) Mendes (Middle). Please help.

Who would select 'thumbs down' on this video? Geeze. Great job, sir!

How do you split names with two first names? Ex. John MIchael P. Jones

Or insert a cell to the right of the one you want to extract the names and dates from, Type the first name, hit enter, press control E. Repeat in additional columns as needed

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!!

thank you very much sir, i was looking for this formula... finally i got it.(2021)

Super sir...

Thank you !!!

Sooo, helpful!

I had to watch 12 different videos before I found one to help me out. I was looking to save time not use up more time than deleting the data 1 by 1 in each cell. You are the only one who provided a simple formula for this process. You are a life saver. THANK YOU!!!!!!!!

what is the formula to extract double first name?
Example name
MARK JAMES S. YAP
I wanto to extract MARK JAMES.
What formula will I use?
Thank you.

How do remove the parentheses in the year column?

it's great thanks a bunch. What about the one that have more than one middle name?

thanks loads

Suggestion: Next time you make a video move your mouse out of the cell, kinda tough to see all of the characters. ALSO, your narration isnt accurate with your entries.

To extracting middle portion of string with MID function "=MID(A1,FIND(" ",A1)+1,FIND(" ",A1)-1)" this formula is ok, can you explain, why need to add more find function with it.

Thank you HERO!

You don't even consider it necessary to share the formula in the description.

Very helpful.. thank you

besides spaces, what else can you find using this formula?

Zoom karo sir

amizing

सर‚ यदि मान लीजिए एक्सेल में कोई कॉलम हो और उसमें दो डेटा एक ही कॉलम में प्रदर्शित हो रहा है। ऐसी स्थिति मे हम उस एक ही कॉलम के डेटा को अलग–अलग काॅलम में कैसे व्यवस्थित कर सकते है।
for Example - B290000185076,11389

What will do, If only two names and pull up lat name and second last name?

thank you very mach dear, this is Great  formula and good explanation thank you again
Best Regards

Not visibility

Greate video thanks

your not actually dealing with Middle Name and the initials??

Great

Misleading because everyone thinks you’re going to show even the columns with a middle initial 😒

What about that 8th row

Dude....This is the worst way to do it. Just opendata, text to columns, select space as the delineation and go.....does the whole thing in less than a minute. Nobody uses this formula.

This was very helpful. Thank you!!!

Thank you very much for the video:) Great explanation. Much appreciated it!!!

You didnt pull the middle name. Only the first and the last name

If Multipal Number in One Row So What can i Do

Please Help. how to extract the: address--city--state--zip code to get each in it's own cell; AND HAS NO COMMA after the street address? EX 12345 NE 6 AVE North Miami Beach, FL 33339

Great!!! Million Thanks

What about the ligne n8
John Quincy Adams (1825-1829)