add email address to a list of names

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"
> <Biochemist@discussions.microsoft.com> 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
> >Smith_John@somewhere.com and cell c2 Brown_Peter@somewhere.com, 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" <biochemist@discussions.microsoft.com> wrote in message news:27D3FA43-B372-4C33-A029-796788903128@microsoft.com...
> >> >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 Smith_John@nowhere.com. 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"
<Biochemist@discussions.microsoft.com> 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"
>> <Biochemist@discussions.microsoft.com> 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
>> >Smith_John@somewhere.com and cell c2 Brown_Peter@somewhere.com, 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" <biochemist@discussions.microsoft.com> wrote in message news:27D3FA43-B372-4C33-A029-796788903128@microsoft.com...
>> >> >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 Smith_John@nowhere.com. How do I add a column that would be a email
>> >> > address of each of the different people
>> >>
>> >>
>> >>
>>
>>