As Ashish rightly points out, these functions will work if your percentages
are written in ascending order. However, in cases where your text may look
like this
10+2 with 60% with pcm or 45% in the aggregate, it will return 60%, not 45%
To tackle this issue, try the following array formula
=IFER
Try this:
=IF(ISERROR(MID(A2,FIND("%",A2,1)-2,3)),"",MID(A2,FIND("%",A2,1)-2,3))
On Sat, Oct 1, 2011 at 3:08 PM, karan 1237 wrote:
> Hello All,
>
> Hope you all are doing well. I'm here as usual, need your assistance. I'v
> text data which have percentage numbers (50% or 60%), I need to extract
Hi
ur %ages are in ascending order in a cell try this
formula IFERROR(MID(A2,FIND("%",A2)-2,3),"")
On Sat, Oct 1, 2011 at 3:08 PM, karan 1237 wrote:
> Hello All,
>
> Hope you all are doing well. I'm here as usual, need your assistance. I'v
> text data which have percentage numbers (50% or 60
Hello All,
Hope you all are doing well. I'm here as usual, need your assistance. I'v
text data which have percentage numbers (50% or 60%), I need to extract
minimum percentage number. Kindly help me to sort out this problem.
Text is : minimum qualification pcm with 50% or MCA 60%
Result should be