Hi,

I need help for the following:

A1 : A10 = each cell contains 7 words or more
B1 : B10 = I would like to search for the word PO then once found get the word after it. For exmple A1 = XXXXX YYYYY PO 98760 WWWW ZZZZ
on B1 I would like 98760 appears.

Please help.