FORMULa

chobits · Jul 6, 2004

Please help me create formula on column C and the output
would be (e.g [email protected])
e.g.

columnA columnB columnC
Arthur Chua [email protected]

thanks!
morepower!!!!

JulieD · Jul 6, 2004

Hi

=LOWER(LEFT(A1,1)&"."&B1&"@mci.com")

this will return the email address but not as a hyperlink .. if you want a
hyperlink, please post back.

Cheers
julieD

FORMULa

chobits

JulieD