Limortz
06-26-2018, 05:48 AM
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?
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?