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