how do i combine three columns in excel.

E

excel help

I separated a long list of emails using test to columns separating them using
the @ separator. I have two columns now and have corrected the emails but
there is no @ sign. I was going to put a column of @ signs but I still can't
combine all the columns. I have over 2000 personal emails to combine.
thanks
bernie
 
E

excel help

I tried that but it goes nowhere. Do I write it in the cell or do I have to
bring it in thru a function or formula.
 
E

excel help

I get an error message that spots the b1

excel help said:
I tried that but it goes nowhere. Do I write it in the cell or do I have to
bring it in thru a function or formula.
Click to expand...
 
D

Dave Peterson

What columns hold your data. I assumed columns A and B.

I put that formula in C (actually C1) and dragged down.

You need that helper column of formulas.
 
Top