Forum Discussion
Excel rules
Hello, I'd like to set up a formula or rule that enables an email address to automatically appear when I add a name into the spreadsheet. For example, if I entered ANDREWS in column A, EMMA int...
Hi Emma,
You can use a formula such as this one:
=LOWER(CONCATENATE(IF(Starting_Part="First Name",A2,B2),
Separator,
IF(Starting_Part="First Name",B2,A2),
"@"&Email_Provider&".com"))
To make the formula dynamic, I've used some options in the right table and made the formula refer to them.
Please find the attached file
Hope that helps
Thank you very much, that's exactly what I needed.