Hi

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"P ercent = ",""),"of
total",""),"of parcel",""),"split is ","")*1
Or 4 times search & replace all to replace all 4 parts of string with ""


Arvi Laanemets


"Mike" wrote in message
...
I need a formula to extract a % from a text string.

Examples of text:

Percent = 12.45% of total
24.56% of parcel
split is 23%

Any help is appreciated.

Thanks,
Mike