Excel fetch first string from column A and second from column B.

Recently had a custom requirement to auto populate PASSWORD column, while considering each password must be unique and self understood by users.
Requirement was to use the variables unique to each user:

• NAME
• PIMARY IDENTIFIER
• SYSTEM_DATE

and using these variables auto populate a unique password per user.
I used formulas CONCATENATE, LEFT and MID to create the logic.

Hope it may help someone in some way.

IDENTIFIER	NAME	PASSWORD_GENERATED	FORMULA USED
12345	abcd	123ab	=CONCATENATE(LEFT(A1,3),LEFT(B1,2))
12346	efgh	1e2f320190429	=CONCATENATE(LEFT(A2,1),LEFT(B2,1),MID(A2,2,1),MID(B2,2,1), MID(A2,3,1),TEXT(TODAY(),"YYYYMMDD"))
12347	ijlk
12348	mnop