How to use a function to implement a naming convention?
 

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

How to use a function to implement a naming convention?
 

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

How to use a function to implement a naming convention?
 

Say the first name is in column A and the last name is in column B. In C1
enter:

="ABC1" & LEFT(A1,5) & LEFT(B1,2)

--
Gary''s Student - gsnu200828


"bestrada" wrote:

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