Serach for text

I need to find either a 4 character string from text which starts with WP.

I have used the following function:
=UPPER(MID(H482,SEARCH("wp",H482,1),4))

from text such as MSI wp69

But the problem I have is, what if there is a gap between the WP & the 69? How can I get it to find it if there is a gap? (eg can I check it theres a space after the WP, and if there is select 5 characters?)

Thanks

Rodney

Try

=UPPER(MID(H482,SEARCH("wp",H482),4+(MID(H482,SEARCH("wp",H482)+2,1)=" ")))

thanks Daddylonglegs,

can I get the result to be trimmed ie only 4 chraracters? eg WP69 (without space)

Cheers

Rod

You can adapt the above, i.e.

=SUBSTITUTE(UPPER(MID(H482,SEARCH("wp",H482),4+(MID(H482,SEARCH("wp",H482)+2,1)=" ")))," ","")

or perhaps a slightly different approach

=UPPER(LEFT(SUBSTITUTE(REPLACE(H482,1,SEARCH("wp",H482)-1,"")," ",""),4))

excellent, the top one works.

Thanks you very much, this is my first time here & I'm very impressed with the result!

Thanks

Rod