How can I remove blank spaces from fields

  • Thread starter Thread starter nozzaworld
  • Start date Start date
N

nozzaworld

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
 
Hi,
I assume your information is in column A, then in another column enter

=trim(A1)

Overwrite column A with new column copying as value
 
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.
 
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
 
Hi,
could you please explain what is not working, Mike formula works for me when
the space is in the middle of the name
 
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
(e-mail address removed)

Many thanks
 
try

=RIGHT(SUBSTITUTE(A1," ",""),256)

nozzaworld said:
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
(e-mail address removed)

Many thanks
Click to expand...
 
Back
Top