remove space

[capreecorn]

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

 

[Mike H]

Try

=SUBSTITUTE(A1," ","")

Mike

 

[capreecorn]

thanks dear, how can i remove the space in start of value in cell.

 

[Shane Devenshire]

hi,

first if you use SUBSTITUTE the cell contains a text entry and you say value.

second to remove trailing and leading spaces use:

=TRIM(A1)

It also removes extra spaces between characters (extra being more than 1)

In both case your results are text, to change them to values the easiest way
is to

=--TRIM(A1)
or
=--SUBSTITUTE(A1," ","")

You can combine both of these

=--TRIM(SUBSTITUTE(A1," ",""))

 

[David Biddulph]

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

thanks dear, how can i remove the space in start of value in cell.