excel 2003: creating a standard email address from a list of names

[mackinlay]

Hi everyone,

I am looking to turn a list of names and companies [eg (A1) Joe Bloggs (B1) Microsoft] into an email address in a standard format where all email addresses take the form: name.surname@company.com (e.g. Joe.Bloggs@microsoft.com). The completed email address can then be displayed in cell C1.

I know that this can be done pretty simply, but i just cant figure out how to get it to work properly!

Any help would be much appreciated.

Cheers,

Alex