Need to trim text!

[Mike]

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

 

[DataDay]

Try this

right("[email protected]"
,len("[email protected]")-instr(1,"[email protected]","@"))

 

[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)