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 fred.bloggs@address.company.au
Mary Brown mary.brown@address.company.au
Ally Ally ally.ally@address.company.au

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