Thread
:
How can I remove blank spaces from fields
View Single Post
#
7
Posted to microsoft.public.excel.misc
Eduardo
external usenet poster
Posts: 2,276
How can I remove blank spaces from fields
try
=RIGHT(SUBSTITUTE(A1," ",""),256)
"nozzaworld" wrote:
It seems to work for short fields like removing the space from nozza world.
However, it does not seem to work with spaces at the end of emails e.g
Many thanks
--
nozzaworld
"Eduardo" wrote:
Hi,
could you please explain what is not working, Mike formula works for me when
the space is in the middle of the name
"nozzaworld" wrote:
Thanks, but neither of these seem to be working with my records (which are
email addresses) when I copy the values back into column A.
Any thoughts?
Regards
--
nozzaworld
"Mike H" wrote:
Hi,
Try this
=SUBSTITUTE(A1," ","")
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"nozzaworld" wrote:
Hi,
I have a column of fields with some duplications. I want to remove those
duplications but all of the duplicates have a space at the end of them so are
not recognised as being true duplicates.
My question is, how do I remove the spaces from my data?
e.g. so that the two fields below both read nozzaworld
nozzaworld
nozza world
Many thanks
--
nozzaworld
Reply With Quote
Eduardo
View Public Profile
Find all posts by Eduardo