Forum Discussion
Emma Andrews
Aug 24, 2018Copper Contributor
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...
Philip West
Aug 24, 2018Iron Contributor
=B1 & "." & A1 & "@Hotmail.com"
Assuming that they are all Hotmail addresses anyway..
Emma Andrews
Aug 24, 2018Copper Contributor
Thank you!