% Excel

[NataliaBarba]

Hi, 

I need help please. I have a lot of this cell (7.888(9,22%)) but i need only the %. ¿is there any formula available for that?

So thanks 

[#2]

@NataliaBarba 

=MID(B4,SEARCH("(",B4,SEARCH("(",B4)+1)+1,SEARCH("%)",B4)-(SEARCH("(",B4,SEARCH("(",B4)+1)+1))

You can try this formula which returns the expected results in my sheet.

 

[#3]

=EXTRAE(L10;ENCONTRAR("(";L10;ENCONTRAR("(";L10)+1)+1;ENCONTRAR("%)";L10)-(ENCONTRAR("(";L10;ENCONTRAR("(";L10)+1)+1))
so thanks but any error? #¡VALOR!

3.326,52(9.89%) maybe for this

[#4]

@NataliaBarba 

3.326,52(9.89%)

For this data layout you can try the following formula:

=MID(C3,SEARCH("(",C3)+1,SEARCH("%)",C3)-(SEARCH("(",C3)+1))