View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nozzaworld nozzaworld is offline
external usenet poster
 
Posts: 8
Default How can I remove blank spaces from fields

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