Extract Email Address From Field and Place in New Column

Hi,

Our 10 year old Access database has a field called ?Notes?, traditionally used for putting notes against Companies. As E-mails have become ever more important, this notes field was used for storing E-mail address, as well as notes.

We now have a database with Notes and E-mails in the same column. My question is, In Access/Excel/VBA, how can I get this data from this column, and put ?only? the E-mail address in the next column?