Removing blank spaces from the ends of email fields?

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

nozzaworld

Hi,

I have a list of emails in a column but many of them have a space at the end
of the email address. I need to be able to remove the space and then run an
advanced filter on them to remove any duplications.

An example of the data that has a space on the end which I want to remove
would be:

(e-mail address removed)

I have already tried using =trim(A1) and =SUBSTITUTE(A1," ",""), neither of
which work when I copy the values back into my original column to run the
advanced filter.

Please help me.

Many thanks in advance
 
You probably copied the addresses from another source.
The may contain "non-breaking spaces"; char(160)
Change the space in your Substitute() formula to CHAR(160)
 
Back
Top