Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create user id fm LName, FName
I have a single column for people's full name (Last Name, First Name ex
Samson, Steve). I'd like to extract the person's first initial and last name to create a user id (ssamson). Any help for the function would be appreciated! tks, steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create user id fm LName, FName
=LOWER(MID(A1,FIND(",",A1,1)+2,1)&LEFT(A1,FIND("," ,A1,1)-1))
On Jul 1, 1:34*pm, sjs wrote: I have a single column for people's full name (Last Name, First Name ex Samson, Steve). *I'd like to extract the person's first initial and last name to create a user id (ssamson). Any help for the function would be appreciated! tks, steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create user id fm LName, FName
=LOWER(MID(A1,FIND(" ",A1)+1,1)&LEFT(A1,FIND(",",A1)-1))
"sjs" wrote: I have a single column for people's full name (Last Name, First Name ex Samson, Steve). I'd like to extract the person's first initial and last name to create a user id (ssamson). Any help for the function would be appreciated! tks, steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create user id fm LName, FName
This will do what you asked...
=LOWER(LEFT(MID(A1,FIND(",",A1)+2,1)&A1,FIND(",",A 1))) But, I have a friend whose last name contains a space (Della Rossa)... if he was in your list, I'm guessing you would not want the space to appear in your user ID, so consider using this more universal modification to the above formula... =SUBSTITUTE(LOWER(LEFT(MID(A1,FIND(",",A1)+2,1)& A1,FIND(",",A1)))," ","") Rick "sjs" wrote in message ... I have a single column for people's full name (Last Name, First Name ex Samson, Steve). I'd like to extract the person's first initial and last name to create a user id (ssamson). Any help for the function would be appreciated! tks, steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create dictionary of terms, create first time user site | New Users to Excel | |||
How to create & use User Forms | Excel Discussion (Misc queries) | |||
How do I copy information to the ascending by LName worksheet? | Excel Worksheet Functions | |||
change lname, fname to fname last name | Excel Discussion (Misc queries) | |||
how do i reference data in a file with the fname in another cell? | Excel Worksheet Functions |