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:

Row	Column C	Column D	Column E
	Tax %	New %	Tax Code Description
11	0		Albania Non-Recoverable 10% VAT Medical
12	0		Albania 20% Non-Recoverable VAT
13	0		ARM 20% VAT
14	0		Northwest Balkans 17% Non-recoverable Tax
15	0		Taxe sur la valeur ajoutée 18%
16	0		Taxe à l'importation - TS (variable)
17	0		BF4 - Droits d'enregistrement des baux 5%
18	0		Cambodia 10% VAT Non-Recoverable
19	0		VAT 19%
20	0		CN1 VAT 17% Non-Recoverable Tax
21	0		DPRK Std Rate VAT Non-Recoverable (China)
22	0		Lebanon Std TDS 7.5% Income tax for Non-residents
23	0		MOZ IVA Water 12.75% - not recoverable

<tbody>
</tbody>

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],"")