First Name & Last Name

  • Thread starter Thread starter Fareez
  • Start date Start date
F

Fareez

Dear Friends
I want help in folowing

Name e mail ID
Mohamed Fareez (e-mail address removed)

I have to create e mail ID for staffs it shold contain firsn name and First
latter of the last name (as per above example). how i can use formula

thx
 
=LOWER(LEFT(A2,B2-1)&MID(TRIM(A2),B2+1,1))&"@unops.org"
Regards,
Stefi


„Fareez†ezt írta:
 
Sorry, I forgot to explain what is in B2:
=LOWER(LEFT(A2,SEARCH(" ",A2)-1)&MID(TRIM(A2),SEARCH("
",A2)+1,1))&"@unops.org"
Stefi


„Stefi†ezt írta:
 
Back
Top