How to use a function to implement a naming convention?

  • Thread starter Thread starter bestrada
  • Start date Start date
B

bestrada

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
 
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)
 
Back
Top