C
capreecorn
How can i remove single space between two values by putting formula ie 2 2
into 22.
into 22.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Try
=SUBSTITUTE(A1," ","")
Mike
=SUBSTITUTE(A1," ","")
Mike
C
capreecorn
thanks dear, how can i remove the space in start of value in cell.
S
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," ",""))
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," ",""))
D
David Biddulph
=RIGHT(A1,LEN(A1)-1)
--
David Biddulph
--
David Biddulph
capreecorn said:thanks dear, how can i remove the space in start of value in cell.