Hi Proteus,

Try posting the entries from notepad into Open Office. This should then have the entries on their own row. Then, you can begin to manipulate the data…

Assuming that you have the text in Column A...

In column D copy & paste the following...

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("@",A1)-1)," ",REPT(" ",99)),99))&MID(A1,FIND("@",A1),FIND(" ",A1&" ",FIND("@",A1))-FIND("@",A1))

and you should find this will extract the e-mail address contained within the string of A1. This is not my own work, you can find the details at the following URL…

http://www.yogeshguptaonline.com/200...ract-from.html

Hope this helps.