Hi, hopefully somebody who has had a similar problem can help.
I'm using excel 03. I have a database in excel format which I would like to use and convert to csv to put it into outlook.
there are twelve thousand entries in it.

In every row it reads as such ie;

[email protected] SMTP [email protected]

I would like to be able to remove the SMTP and anything after that, leaving just the initial email address in the row.
I have other smaller databases of say 200 or so which I just simply manually deleted the SMTP bit etc that didn't take me a long time,
but twelve thousand would take me a weeks work non stop to complete.

Anybody have any suggestions as to how I can remove the SMTP bit etc without it taking me forever?
any help greatly appreciated