Extract a word from a text in a tab

[Limortz]

Hi All,

I would like to extract a word from a text, only with with formulas:

"You have a new message: Via:xx Message Details: First Name Dror Last Name test Your Email xx Job Title popo Direct Manager popo Team popop Form Name Presentation"

The colored words should be extracted (in different cells).
In each kine only those words are being changed.

I tried the following formula but it returns
=MID(A2, SEARCH("First Name",A2) + 1, SEARCH("last",A2,SEARCH("First Name",A2)+1) - SEARCH("last",A2) - 1)

Any ideas?

[mancubus]

Dror:

=MID(A2,(SEARCH("First Name",A2)+LEN("First Name ")),(SEARCH(" Last Name",A2))-(SEARCH("First Name",A2)+LEN("First Name "))) 

test:

=MID(A2,(SEARCH("Last Name",A2)+LEN("Last Name ")),(SEARCH(" Your Email",A2))-(SEARCH("Last Name",A2)+LEN("Last Name "))) 

[Limortz]

Great, works!
Thank you !