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.