So I have a long list of email address that my company uses for our newsletter
in an excel spreadsheet.

We've noticed that all recipients at earthlink.net have trouble with our html format.

I am trying to search the column an pull out all of the emails from earthlink.net and put them into a separate column, so that we can send them non-html rich letters.

I image there is some VB script that will help me separate the data and paste it into a new column thus saving me hours of extra work.

Any suggestions?