Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating username and passwords
I need help creating all lower case usernames made up of the first letter of the customers first name and the first 7 letters of their last name. I also need help creating passwords which will be made up of a customers first and last initial, followed by a random 6 digit number. the first character in the password will be lower case and the second character will be upper case. Full Name Last Name First Name Username Password Boxer, Barbara Boxer Barbara Cantwell, Maria Cantwell Maria Craig, Larry Craig Larry Crapo, Michael Crapo Michael Ensign, John Ensign John Feinstein, Dianne Feinstein Dianne Murray, Patty Murray Patty Reid, Harry Reid Harry Smith, Gordon Smith Gordon Wyden, Ron Wyden Ron I need help creating functions for these tasks -- shannyshanhan ------------------------------------------------------------------------ shannyshanhan's Profile: http://www.excelforum.com/member.php...o&userid=37173 View this thread: http://www.excelforum.com/showthread...hreadid=568903 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a template for username and password storage for Excel? | Excel Discussion (Misc queries) |