First Name & Last Name

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
 
S

Stefi

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


„Fareez†ezt írta:
 
S

Stefi

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:
 

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

leve chart 5
Separate first name, middle name and last name 2
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Large Data File Consolidation... 2
Lookup a name if cell value first letter is in a range 1
Duplicate entries 5
Create user id fm LName, FName 3
Change Names to E-Mail addresses Q 4

Top