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

Try

=SUBSTITUTE(A1," ","")

Mike

"capreecorn" wrote:

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

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.

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," ",""))


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"capreecorn" wrote:

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.

=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.