=trim(a1)
************
Anne Troy
www.OfficeArticles.com

"shikha" wrote in message
...
I have a number written in one of the cells before which there is a space .
I
cannot do any calculation because of that space. How do i remove that
space
from beginning of the text such that it gets converted to a number