="ABC1"&LOWER(LEFT(A2,5))&LOWER(LEFT(B2,2))
--
David Biddulph

"bestrada" wrote in message
...
I've seen people use a function so that they don't have to manually create
a
user id. Could someone tell em the general function used to do so?

For Example:
First Name: Maria
Last Name:Gonzales
Naming Convention details: pre-fix: 'abc1'+ '1st 5 letters of first name'+
'2 letters from last name'.

Creates: ABC1mariago