add email address to a list of names
 

I have a list of names, 1st column has last name, 2nd column has first name
and I know what the email address would be for each person: example would be
like . How do I add a column that would be a email
address of each of the different people

Hi biochemist

Try this formula

=HYPERLINK("mailto:" & A1 & ")

--
Regards Ron de Bruin
http://www.rondebruin.nl



"biochemist" wrote in message ...
I have a list of names, 1st column has last name, 2nd column has first name
and I know what the email address would be for each person: example would be
like . How do I add a column that would be a email
address of each of the different people

I guess I was not very clear I need to do this to a whole series of cell:
example would be like Cell A1 Smith, Cell B1 John, and then in cell a2 Brown
cell b2 Peter etc€¦ and what I want is to be able to do this from say a1 to
a1054 and b1 to b1054 and in cell c1 to c1054 have the read
and cell c2 , they would
all have the same .somewhere.com. I hope I was more clear here than in the
last time.

"Ron de Bruin" wrote:

Hi biochemist

Try this formula

=HYPERLINK("mailto:" & A1 & ")

--
Regards Ron de Bruin
http://www.rondebruin.nl



"biochemist" wrote in message ...
I have a list of names, 1st column has last name, 2nd column has first name
and I know what the email address would be for each person: example would be
like . How do I add a column that would be a email
address of each of the different people

Just copy Ron's formula down Column C as far as you wish(1054 rows?)

OR double-click on the fill handle(square lump on bottom right corner of C1)
to fill down if data is contiguous in column B.


Gord Dibben Excel MVP


On Mon, 16 May 2005 16:04:02 -0700, "Biochemist"
wrote:

I guess I was not very clear I need to do this to a whole series of cell:
example would be like Cell A1 Smith, Cell B1 John, and then in cell a2 Brown
cell b2 Peter etc… and what I want is to be able to do this from say a1 to
a1054 and b1 to b1054 and in cell c1 to c1054 have the read
and cell c2 , they would
all have the same .somewhere.com. I hope I was more clear here than in the
last time.

"Ron de Bruin" wrote:

Hi biochemist

Try this formula

=HYPERLINK("mailto:" & A1 & ")

--
Regards Ron de Bruin
http://www.rondebruin.nl



"biochemist" wrote in message ...
I have a list of names, 1st column has last name, 2nd column has first name
and I know what the email address would be for each person: example would be
like . How do I add a column that would be a email
address of each of the different people

Super, thanks but how do you get the underscore to appear betwenn first and
last name with no space?

"Gord Dibben" wrote:

Just copy Ron's formula down Column C as far as you wish(1054 rows?)

OR double-click on the fill handle(square lump on bottom right corner of C1)
to fill down if data is contiguous in column B.


Gord Dibben Excel MVP


On Mon, 16 May 2005 16:04:02 -0700, "Biochemist"
wrote:

I guess I was not very clear I need to do this to a whole series of cell:
example would be like Cell A1 Smith, Cell B1 John, and then in cell a2 Brown
cell b2 Peter etc€¦ and what I want is to be able to do this from say a1 to
a1054 and b1 to b1054 and in cell c1 to c1054 have the read
and cell c2 , they would
all have the same .somewhere.com. I hope I was more clear here than in the
last time.

"Ron de Bruin" wrote:

Hi biochemist

Try this formula

=HYPERLINK("mailto:" & A1 & ")

--
Regards Ron de Bruin
http://www.rondebruin.nl



"biochemist" wrote in message ...
I have a list of names, 1st column has last name, 2nd column has first name
and I know what the email address would be for each person: example would be
like . How do I add a column that would be a email
address of each of the different people

Assuming you have no spaces in A1 and B1.........

=HYPERLINK("mailto:" & A1 & "_" & B1 & ")


Gord

On Tue, 17 May 2005 07:42:03 -0700, "Biochemist"
wrote:

Super, thanks but how do you get the underscore to appear betwenn first and
last name with no space?

"Gord Dibben" wrote:

Just copy Ron's formula down Column C as far as you wish(1054 rows?)

OR double-click on the fill handle(square lump on bottom right corner of C1)
to fill down if data is contiguous in column B.


Gord Dibben Excel MVP


On Mon, 16 May 2005 16:04:02 -0700, "Biochemist"
wrote:

I guess I was not very clear I need to do this to a whole series of cell:
example would be like Cell A1 Smith, Cell B1 John, and then in cell a2 Brown
cell b2 Peter etc… and what I want is to be able to do this from say a1 to
a1054 and b1 to b1054 and in cell c1 to c1054 have the read
and cell c2 , they would
all have the same .somewhere.com. I hope I was more clear here than in the
last time.

"Ron de Bruin" wrote:

Hi biochemist

Try this formula

=HYPERLINK("mailto:" & A1 & ")

--
Regards Ron de Bruin
http://www.rondebruin.nl



"biochemist" wrote in message ...
I have a list of names, 1st column has last name, 2nd column has first name
and I know what the email address would be for each person: example would be
like . How do I add a column that would be a email
address of each of the different people