Adding my forgotten : in the second search should work for any text without
p:
AND, will compensate for upper/lower by using SEARCH instead of FIND
=MID(A3,SEARCH("p:",A3)+2,FIND("%",A3)-SEARCH("p:",A3)-2)



--
Don Guillett Excel MVP
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
try
=MID(A3,SEARCH("p:",A3)+2,FIND("%",A3)-SEARCH("p",A3)-2)
to get

That won't work if the "blah" at the beginning of the string were short
for "blah-blah-blah" (meaning some piece of unknown text) and that piece
of unknown text contained a "p" in it.

Rick