Excel 2007 : Merging columns into email address

**Cambronze** · 08-06-2010, 10:50 PM

G'day All,

OS Windows XP
Excel version 2007

I have two columns. One is called first name the second is called last name.

I wish to create a third column that is of the format of
firstname.lastname@address. company.au

The idea being that the third column would be populated by data from column 1 and column 2 with the fixed part of the email address appended as in the example above.

Thus I would get a result such as
First name Last name Email address
Fred Bloggs [email protected]
Mary Brown [email protected]
Ally Ally [email protected]

I realise that it may be difficult to change the capitalisation.
Any and all help gratefully received
Cambronze

**DonkeyOte** · 08-07-2010, 01:51 AM

In terms of the concatenation

C1: =LOWER(A1&"."&B1&"@address.company.au")

where A1 holds First Name & B1 Last Name

If you wish for the above to be valid hyperlinks then

C1: =HYPERLINK(LOWER("mailto:"&A1&"."&B1&"@address.company.au"))

You can append the hyperlink string to alter the mail content, eg:

"mailto:etc...?subject=example&body=Hello%0A%0AHow%20Are%20You?"