Generating password by Appending characters to the end of a cell based on length.

I hope that title was descriptive enough, as I don't really know what this would entail.

I work as the IT Specialist at a small school and am trying to make adding users into our system a little easier using excel formulas. The problem I'm having is creating a formula to make passwords for our users. The usernames are first letter of first name + full last name. The passwords though, are their usernames and if that is less than 8 characters long we add numbers in sequential order. For example: Jim Brown = jbrown12, Tim Bob = tbob1234, Lacey Smithers = lsmithers, etc.

I already have formulas to get the first initial and last name concatenated and I think I'm on the right track for the password as I can get the length of the name, but I'm having issues with adding the numbers to the end of the string.

I'm using an =IF() statement right now: =IF(LEN(E2)<8,E2,??)

Thank you so much to any help at all!

Thank you so much!! That definitely did the trick. You've definitely saved me much time!