When I am using Excel16 or Excel 16 for Mac.
I have 3 columns
A B C
1 first name last name password
2 John Smith =left(a2,3)&left(b2,3)&len(b2) JohSmi5
How do I get the formula to display JohSmi05.
If the last name is less than 10 characters, I need the zero to appear in there. How to I make this possible??