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 [email protected]. 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 & B1&"@something.com")

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



"biochemist" <[email protected]> wrote in message news:[email protected]...
>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 [email protected]. 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
[email protected] and cell c2 [email protected], 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 & B1&"@something.com")
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "biochemist" <[email protected]> wrote in message news:[email protected]...
> >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 [email protected]. 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"
<[email protected]> 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
>[email protected] and cell c2 [email protected], 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 & B1&"@something.com")
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "biochemist" <[email protected]> wrote in message news:[email protected]...
>> >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 [email protected]. 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"
> <[email protected]> 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
> >[email protected] and cell c2 [email protected], 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 & B1&"@something.com")
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "biochemist" <[email protected]> wrote in message news:[email protected]...
> >> >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 [email protected]. 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 & "@something.com")


Gord

On Tue, 17 May 2005 07:42:03 -0700, "Biochemist"
<[email protected]> 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"
>> <[email protected]> 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
>> >[email protected] and cell c2 [email protected], 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 & B1&"@something.com")
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >>
>> >> "biochemist" <[email protected]> wrote in message news:[email protected]...
>> >> >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 [email protected]. How do I add a column that would be a email
>> >> > address of each of the different people
>> >>
>> >>
>> >>
>>
>>