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