View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seemore Seemore is offline
external usenet poster
 
Posts: 19
Default excel not finding spaces in email addresses when searching

I have a list of email address that I copy and paste into Outlook. I
keep getting errors in Outlook when sending my emails and the culprit
appears to be extra spaces at the end of some of the email addresses.
I have done file/replace and it found 66 and deleted the spaces.
However, I am still having the issue and if I go down line by line and
click in each cell, I will eventually find the one line which has
extra spaces. Why can't excel find these and is there a better way of
removing them? I have about 1500 addresses so going line by line
really sucks.

Thanks