inserting an @ character in a string

Question

Hi,

I have a series of emails that are missing the @ before the gmail.com domain.

the length of the emails is variable, but they all finish with gmail.com

Could you please help me with the formula in order to insert the @ sign before the gmail.com domain name?

thank you very much

Paola

KilianL · Accepted Answer

Try this formula: replace([field], 'gmail.com','@gmail.com')