isolate the first name in this text string

Hi,

I have a hundreds of text strings like the example ones attached.
How would I isolate the first name (name in middle of sting)?
Thank you!


text string example.xlsx

Try

=TRIM(MID(SUBSTITUTE(TRIM(A3)," ",REPT(" ",LEN(A3))),LEN(A3),LEN(A3)))

i've never used trim before
Thank you!

Great, glad to help.