View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seemore Seemore is offline
external usenet poster
 
Posts: 19
Default removing extra spaces in excel

I have a page of email addresses that I send out in bulk.
Occasionally, when I copy and past the addresses into outlook, I get
an error. The error, I found out, is becasue there is an extra space
(most likely at the end) of the address. I have done searches using
the "find" command but for what ever reason it doesn't seem to find
the spaces all of the time.

Is there a way to search and even remove the extra spaces?

Thanks in advance.