Forum Discussion

NataliaBarba's avatar
NataliaBarba
Copper Contributor
Aug 11, 2022

% Excel

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 
excel
NataliaBarba's avatar
NataliaBarba
Copper Contributor
Aug 11, 2022

=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

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Aug 11, 2022

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))