database problem in excel

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

thanks very much for your reply oldchippy, but I couldn't get this to work.
all that happened is that when I entered it into B1 it came back with an error saying 'a value in the formula is of the wrong data type' it left #VALUE! in the box too...I appreciate any further help you may be able to give

thanks Dave

yes it is all in the one cell A1 down to A12k

Thanks Dave