Extracting a middle word in cell without space separation

[sergiopcrt]

Hello everyone,

I need to extract the FirstName from cells in a particular format LastName,FirstName MiddleName1 MiddleName2
Note that LastName,FirstName has no space in between, only the comma so I adapted a formula I found on google to:
=MID(A10,SEARCH(",",A10,1)+1,SEARCH(" ",A10,SEARCH(" ",A10,1)+1)-SEARCH(",",A10,1))

but it is still returning FirstName MiddleName1 and other variations return FirstName Mi

From my google searches and in this forum I got no results. Can you help me on this?

Season's greetings!

 

[steve the fish]

Try:

=MID(LEFT(A1,FIND(" ",A1)-1),FIND(",",A1)+1,999)

 

[steve the fish]

If you wanted this one can be dragged right and will produce all the names in order:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,","," ")," ",REPT(" ",LEN($A1))),(COLUMNS($A$1:A1)-1)*LEN($A1)+1,LEN($A1)))

 

[sergiopcrt]

Try:

=MID(LEFT(A1,FIND(" ",A1)-1),FIND(",",A1)+1,999)

It works like a charm!!! So simple it's almost annoying
Thank you so much Steve!! Take care

 

[sergiopcrt]

If you wanted this one can be dragged right and will produce all the names in order:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,","," ")," ",REPT(" ",LEN($A1))),(COLUMNS($A$1:A1)-1)*LEN($A1)+1,LEN($A1)))

Also very useful, this is like the gourmet version of the previous one