Why do you want to extract it?
Yopu can replace using editreplace, find what %, leave replace with blank

If you need a formula to extract it use

=MID(A1,FIND("%",A1),1)

Regards,

Peo Sjoblom



"Mike" wrote:

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