Is there a formula to populate email addresses from existing data

[CherryM2015]

Sample ExcelData.jpg

The image shows 3 columns, one with first name, one with surname and 3rd with generic email address. is there a way to create the correct email address for each person?

Thanks in Advance

[berlan]

Try,

D2: =LOWER($A2&"."&$B2)&MID($C2,FIND("@",$C2),255)

and copy down.

[CherryM2015]

Perfect! Thank you!