Hi!
Here's one way:
=--MID(A12,MIN(SEARCH
({0,1,2,3,4,5,6,7,8,9},A12&"0123456789")),FIND("%" ,A12)-MIN
(SEARCH({0,1,2,3,4,5,6,7,8,9},A12&"0123456789")))
This will return 12.45 as a numeric value. If you want
the value formatted as a percent, you will have to format
the cell as percent then use this formula:
=--MID(A12,MIN(SEARCH
({0,1,2,3,4,5,6,7,8,9},A12&"0123456789")),FIND("%" ,A12)-MIN
(SEARCH({0,1,2,3,4,5,6,7,8,9},A12&"0123456789"))+1 )
Biff
-----Original Message-----
I need to extract the numerical value:
ie. "12.45%" from - Percent = 12.45% of total
"24.56% from - amount is 24.56% of parcel
Thanks,
Mike
"Peo Sjoblom" wrote:
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
.
|