Need to trim text!

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
Try this

right("(e-mail address removed)"
,len("(e-mail address removed)")-instr(1,"(e-mail address removed)","@"))
 
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
Click to expand...

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

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