PDA

View Full Version : Extract a word from a text in a tab



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?

mancubus
06-26-2018, 06:35 AM
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
06-28-2018, 01:45 AM
Great, works!
Thank you !