remove % symbol in a cell

hi marvin thanks for the your precious time, i tried the following and got the solution

A1 15.12%
in A2

=LEFT(A1,LEN(A1)-1)



hi experts,

i've the cells with number with percentage symbols i want those "%" symbols to be removed dynamically.

example:
15.12%
12.31%
34.12%

i need
15.12
12.31
34.12

but i can't use replace as it has to happen dynamically.


thanks in advance.

regards
Girish B