Remove % and return only integer value

Hi All,

I have a row where in the values enetered are in %..

like

1%	2%	3%	4%	5%

i am using the below formula in other cell to get these values

=IF(INDEX($1:$1,ROW(A1))="","",(INDEX($1:$1,ROW(A1))))

now the problem is, this will return the value by deviding it by 100..like below

0.01
0.02
0.03
0.04
0.05

but i want a result like below without % symbol.

1
2
3
4
5

also if there is any blank cell in the input then the resultant cell should also show a blank cell..

Please help

Thank you

Originally Posted by vlady

maybe multiply it by 100


=IF(INDEX($1:$1,ROW(A1))="","",(INDEX($1:$1,ROW(A1))*100))

Strange!!

I did the same before which didnt work (may be i was missing something before).. but now after u gave this formula, it is working like a charm

Thanks a lot..