Question

Usernames Worksheet
11. Kids R Us Child Care Centers is creating an online parent portal that parents will access with a username and password. Use a formula to create a username for each parent based on the following rules:
• Lowercase first letter of first name.
• Digit five of ID.
• Uppercase first four letters of last name.
• Last digit of phone number.
• Number of characters in first name.

Parent ID	Parent Last Name	Parent First Name	Parent Phone	Parent Username
100000	Ewing	Levi	(550) 726-7424
100001	Gillespie	Vera	(263) 579-3567
100002	Mccall	Astra	(897) 263-3526
100003	Woodward	Constance	(845) 953-5717

Answer 1

Short Summary:

• Provided the solution and sample output as per the requirements.

**************Please upvote the answer and appreciate our time.************

SOLUTION:

Formula:

=CONCATENATE(LOWER(LEFT(C2,1)),MID(A2&" ",5,1),UPPER(LEFT(B2,4)),RIGHT(D2,1),LEN(C2))

Steps:

Lowercase first letter of first name

• LOWER(LEFT(C2,1))

Digit five of ID.

• MID(A2&" ",5,1)

Uppercase first four letters of last name.

• UPPER(LEFT(B2,4))

Last digit of phone number.

• RIGHT(D2,1)

Number of characters in first name.

• LEN(C2)

After finding the letters using the rules, concatnate them using CONCATNATE function as follows:

=CONCATENATE(LOWER(LEFT(C3,1)),MID(A3&" ",5,1),UPPER(LEFT(B3,4)),RIGHT(D3,1),LEN(C3))

OUTPUT:

Click and Drag through the cells E3to E5

**************************************************************************************

Feel free to rate the answer and comment your questions, if you have any.

Please upvote the answer and appreciate our time.

Happy Studying!!!

**************************************************************************************