Forum Discussion
% 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
3 Replies
=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.
=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
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))
