Search and return a number that is contained within a stiring of text

[My0j0]

Can anyone please help me.

I want to search for a number (%) contained within in a string of text in another cell. E.G.

The data I currently have is listed below:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Row[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tax %[/TD]
[TD]New %[/TD]
[TD]Tax Code Description[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Albania Non-Recoverable 10% VAT Medical[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Albania 20% Non-Recoverable VAT[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]ARM 20% VAT[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Northwest Balkans 17% Non-recoverable Tax[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Taxe sur la valeur ajoutée 18%[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Taxe à l'importation - TS (variable)[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]BF4 - Droits d'enregistrement des baux 5%[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Cambodia 10% VAT Non-Recoverable[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]VAT 19%[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]CN1 VAT 17% Non-Recoverable Tax[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]DPRK Std Rate VAT Non-Recoverable (China)[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]Lebanon Std TDS 7.5% Income tax for Non-residents[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]MOZ IVA Water 12.75% - not recoverable[/TD]
[/TR]
</tbody>[/TABLE]


























I want to search column 'E' for the 'number %' contained within the text and return just the 'number %' (without the rest of the text) in column 'C'

The result I want is -

Row 11 - Column C would return '10%' or '10'
Row 12 - Column C would return '20%' or 20
Row 16 - Column C would return '0' or 'blank'
Row 22 - Column C would return '7.5%' or 7.5
Row 23 - Column C would return '12.75%' or 12.75

Is there a formula that would help me do this?

I would be grateful if anyone could help me find a solution rather than me having to hard key the data.

Thanks in advance

 

[Joe4]

For a value in cell E3, use this formula:

=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(E3,FIND("%",E3))," ",REPT(" ",50)),25)),"")

If you want to turn it into a number without the % sign, you can made this edit:

=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(E3,FIND("%",E3))," ",REPT(" ",50)),25))[COLOR=#ff0000]*100[/COLOR],"")