=RIGHT(A1,LEN(A1)-1)
--
David Biddulph


"capreecorn" wrote in message
...
thanks dear, how can i remove the space in start of value in cell.

"Mike H" wrote:

Try

=SUBSTITUTE(A1," ","")

Mike

"capreecorn" wrote:

How can i remove single space between two values by putting formula ie
2 2
into 22.