=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