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. (e-mail address removed) to *@domain.com.

Thanks
Mike Sund

 

[DataDay]

Try this

right("(e-mail address removed)"
,len("(e-mail address removed)")-instr(1,"(e-mail address removed)","@"))

 

[fredg]

Group

I need to trim everything off of the left side of the @ symbol in a list of
e-mail addresses. (e-mail address removed) 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)