Remove charachters infron of the @ sign in an Email address

[Pete]

Hi
Could you please help me delete all records in front of the @ sign in an
Email address

Thanks
Pete

 

[Allen Browne]

Use Instr() to locate the "@", and then Mid() to get the rest of the field.