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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function similar to "LEFT" 3
Flipping naming conventions to match two tables 3
What function to use? Len? 11
how to create function 2
Convert stored numbers into a set naming convention 4
How to use LEN & LEFT on last name to show only 3 letters 4
usernames and passwords 1
Use Len and Left to make name 3 letters 2

Back
Top