I need to create passwords for new users as they come aboard. The passwords
must be 8 characters. I have a workbook with cells containing their last name
and first name. What I need is a new column which will take the last 6
characters of the last name in reverse (ex. Johnson--nosnho), combine these
6 characters with the last 2 characters of the first name in reverse (ex.
Charles -- se). The final result for the password in this example would be
nosnhose. What will happen if the last name and first name contain less than
8 characters (ex. Jen Lee)?