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 xxx 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?