combining two cells which contain text

J

JK Brooks

Hello,

I have a spreadsheet with first and last name columns. I'd like to
combine them so that the resulting 3rd cell is [email protected]

My first order of business is to test that I don't already have an
email address. This is as far as I've gotten.

A = first
B = last
C = email

in column D
=if(c1>0,c1, . . .

I don't know what to do next. Can you help?
thanks
 
J

J.E. McGimpsey

Hello,

I have a spreadsheet with first and last name columns. I'd like to
combine them so that the resulting 3rd cell is [email protected]

My first order of business is to test that I don't already have an
email address. This is as far as I've gotten.

A = first
B = last
C = email

in column D
=if(c1>0,c1, . . .

I don't know what to do next. Can you help?
thanks
Click to expand...

One way:

D1: =IF(C1<>"",C1, A1 & "." & B1 & "@company.com")
 
Top