List of names to email formular

[trees]

Hi

I have huge list of names "Smith,John" and need to turn them into an email list "smithj@company.com" .Is there a formular to do this?

Thanks

 

[Zack Barresse]

Hi, welcome to the board!!

Assuming this is in A1, maybe ...

=LOWER(LEFT(A1,FIND(",",A1,1)-1)&MID(A1,FIND(",",A1,1)+1,1))&"@company.com"

{untested}

HTH

 

[trees]

Thanks ....i'm off to try it