FORMULa

  • Thread starter Thread starter chobits
  • Start date Start date
C

chobits

Please help me create formula on column C and the output
would be (e.g (e-mail address removed))
e.g.

columnA columnB columnC
Arthur Chua (e-mail address removed)

thanks!
morepower!!!!
 
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
 
Back
Top