| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First Name & Last Name
Sorry, I forgot to explain what is in B2:
=LOWER(LEFT(A2,SEARCH(" ",A2)-1)&MID(TRIM(A2),SEARCH(" " Stefi Stefi ezt *rta: " Regards, Stefi Fareez ezt *rta: Dear Friends I want help in folowing Name e mail ID Mohamed Fareez 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 |
Threaded Mode
