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