If that is a space the below will do. Also note all double spaces within the
text also will be trimmed to a single space.
=TRIM(A1)
Still you see a character after text; then probably it may not be a space.
Check that using the below formula..and replace the character using
SUBSTITUTE()
=CODE(RIGHT(A1,1))
Following formula would be able to remove spaces from words in Excel,
=REPLACE(A1,LEN(A1),1,"")
Jacob Skaria wrote:
If that is a space the below will do.
02-Jun-10
If that is a space the below will do. Also note all double spaces within th
text also will be trimmed to a single space
=TRIM(A1
Still you see a character after text; then probably it may not be a space
Check that using the below formula..and replace the character usin
SUBSTITUTE(
=CODE(RIGHT(A1,1)
Oops..I notice now that the OP needs only 1 space to be removed which could
be achieved either using LEFT() or MID() or REPLACE()....
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.