Extract Key word

[Tempy]

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 ***

 

[Tom Ogilvy]

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