I have one column of email address names without the domain name (kjmerr). I
have a second column with the domain name ). I want to combine the
data from both columns into one column so that I end up with a third column
of email addresses ). Note: the domain name is the same for
all of the names.

C1 contains =A1&B1

KJM wrote:

I have one column of email address names without the domain name (kjmerr). I
have a second column with the domain name ). I want to combine the
data from both columns into one column so that I end up with a third column
of email addresses ). Note: the domain name is the same for
all of the names.

In a helper column.

=A1&B1

Copied down.

When done, copy the helper column and EditPaste Special(in
place)ValuesOKEsc

Assumes your current data is in Columns A and B


Gord Dibben MS Excel MVP

On Wed, 13 Jan 2010 09:02:02 -0800, KJM
wrote:

I have one column of email address names without the domain name (kjmerr). I
have a second column with the domain name ). I want to combine the
data from both columns into one column so that I end up with a third column
of email addresses ). Note: the domain name is the same for
all of the names.