Find Specific string

**janjan_376** · 08-20-2008, 03:13 PM

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.

**se1429** · 08-20-2008, 03:44 PM

Hi,

Try this:

In B1 enter

Please Login or Register  to view this content.

Use autofill to enter formulas in the rest of the cells.

I am assuming that the spacing is always the same in your data, and that the PO is always 5 digits.

Please find here more explanation on how to use the MID and FIND functions in the same formula.
http://www.exceldigest.com/myblog/20...ons-in-a-cell/
Regards.

**Richard Schollar** · 08-20-2008, 03:45 PM

Hi

Try the following in b1 COPIED DOWN:

=LEFT(TRIM(REPLACE(A1,1,FIND("PO",A1&"PO")+1,"")),FIND(" ",TRIM(REPLACE(A1,1,FIND("PO",A1&"PO")+1,""))&" ")-1)

rICHARD

**janjan_376** · 08-21-2008, 12:08 PM

Hi,

Thank you to SE1429 for his time. His idea worked very good as well but I find Richard's formula suit to what I was looking for. Thank you very much for your time Richard.

Thank you 2 both of u