FORMULa

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!!!!
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 5
Need help to fix vlookup function in macro 1
How to replace cell value based on other cell's value using macro 3
Macro to copy top 3 value in column 1
Referenced Cell Values 2
Count continuous duplicates 2
Is this an Index/Match formula? 5
Return Corresponding Value Based on Comparing Two Sheets of Data 6

Top