Excel rules

Question

Hello,&nbsp;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.&nbsp;For example, if I entered ANDREWS in column A, EMMA into column B , I'd like excel to then automatically create the email address in column C as emma.andrews@hotmail.comHow can I do this? I'd also like to be able to easily over write this rule too if needed.&nbsp;Thanks!&nbsp;

haytham amairah · Answer

Hi Emma,&nbsp;You can use a formula such as this one:=LOWER(CONCATENATE(IF(Starting_Part="First Name",A2,B2),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Separator,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Starting_Part="First Name",B2,A2),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "@"&amp;Email_Provider&amp;".com"))&nbsp;To make the formula dynamic, I've used some options in the right table and made the formula refer to them.&nbsp;Please find the attached fileHope that helps

philip west · Answer

=B1 &amp; "." &amp; A1 &amp; "@Hotmail.com"&nbsp;Assuming that they are all Hotmail addresses anyway..

emma andrews · Answer

Thank you very much, that's exactly what I needed.

emma andrews · Answer

Thank you!

Forum Discussion

Excel rules

4 Replies