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

"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