How can I remove blank spaces from fields

[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

 

[Eduardo]

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

 

[Mike H]

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]

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

 

[Eduardo]

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]

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

 

[Eduardo]

try

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

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