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

Maybe just a formula like:

=a1&"@"&b1

dragged down would be enough.

excel help wrote:

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

--

Dave Peterson

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.

"Dave Peterson" wrote:

Maybe just a formula like:

=a1&"@"&b1

dragged down would be enough.

excel help wrote:

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

--

Dave Peterson

I get an error message that spots the b1

"excel help" wrote:

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.

"Dave Peterson" wrote:

Maybe just a formula like:

=a1&"@"&b1

dragged down would be enough.

excel help wrote:

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

--

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.

excel help wrote:

I get an error message that spots the b1

"excel help" wrote:

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.

"Dave Peterson" wrote:

Maybe just a formula like:

=a1&"@"&b1

dragged down would be enough.

excel help wrote:

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

--

Dave Peterson


--

Dave Peterson