Need to trim text!

F

fredg

Group

I need to trim everything off of the left side of the @ symbol in a list of
e-mail addresses. [email protected] to *@domain.com.

Thanks
Mike Sund

Permanently?
Update YourField Set YourField.FieldName =
Mid([FieldName],InStr([FieldName],"@"))

Did you wish to include the asterisk?
If so
="*" & Mid(etc)
 
Top