inserting an @ character in a string

[CiaoPaola]

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 solution]

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

[CiaoPaola]

thank you Kilian!