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: [email protected] (e.g. [email protected]). 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

[reggie1000]

try this

=CONCATENATE(TRIM(LEFT(A1,FIND(" ",A1,1))),".",RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))),"@",B1,".com")

thanks reg

[mackinlay]

Thanks Reg, works like a dream!

Can i run a separate problem by you, but this one is a bit more complicated?! Should i post it as a new topic under programming?

Alex.

[reggie1000]

hi alex,

just post the problem under the relevant criteria.

cheers reg