What the LEN function

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??

By: Michael

Leave a Reply

Your email address will not be published. Required fields are marked *