Pull data after the @ on email address

[Terri]

I need to pull the data after the @ symbol on email addresses.

Example test@hotmail.com

I want to pull only the hotmail.com. Any help would be appreciated.

Thanks!

 

[jfgambit]

Here is a good example of striping charaters from strings:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210103

 

[antomack]

Try the following:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31785