removing a space from starting of the text
 

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

=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

If the OP has many values to change another option might be to use a macro
like this

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards,

Peo Sjoblom

(No private emails please)


"Anne Troy" wrote in message
...
=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

Assuming these are numbers, so contain no other spaces, just use Edit/Replace
and replace the space character with "nothing" (leave the Replace With box
blank).

On Sat, 24 Sep 2005 08:19:02 -0700, shikha
wrote:

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