Extract Key word
 

Good day all,

I have a spreadsheet with the details below in, which is in 3 merged
cells "A1:C1" in the format shown i need to extract the 904XAZA and put
it into a cell, this "Keyword" varies but the lenght does not, could
somebody help me with a bit of code please.

E90/4 8660
31. Mai 05 100%: 2429
Stichworte: 904XAZA; EP: ZA;
SOP: 01.Mrz 2005


Thanks in advance.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

Extract Key word
 

=MID(A1,FIND(":",A1,FIND(":",A1)+1)+2,7)

--
Regards,
Tom Ogilvy



"Tempy" wrote in message
...
Good day all,

I have a spreadsheet with the details below in, which is in 3 merged
cells "A1:C1" in the format shown i need to extract the 904XAZA and put
it into a cell, this "Keyword" varies but the lenght does not, could
somebody help me with a bit of code please.

E90/4 8660
31. Mai 05 100%: 2429
Stichworte: 904XAZA; EP: ZA;
SOP: 01.Mrz 2005


Thanks in advance.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***