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
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
Last edited by reggie1000; 07-09-2008 at 08:01 AM.
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.
hi alex,
just post the problem under the relevant criteria.
cheers reg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks