ANSWERS: 2
  • In column A enter mary, in column B enter google and in column C enter: =CONCATENATE(A1,"@",B1,".com")
  • In addition to Brian's suggestion (which may be preferable, since you could also set up a Data Validation list to select from only pre-listed domains: google.com, yahoo.com, hotmail.com ... plus any others you want to list ONCE and then be able to select from a drop-down), which would simplify because you could: Enter "Mary" in column A Select "@google.com" from a drop-down in column B Combine them much more simply in column C: = a1 & b1 Actually, I'm going to stop there. My other suggestion wasn't nearly so good as this.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy