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