Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
usernames 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 I would like to think the people who answered my post. I have tried to apply what you told me and have had no luck. I am sure it is on my end as this is very new to me. Would one of you possibly be able to explain this to me in simpler terms for my simple mind? Thanks Shannon -- shannyshanhan ------------------------------------------------------------------------ shannyshanhan's Profile: http://www.excelforum.com/member.php...o&userid=37173 View this thread: http://www.excelforum.com/showthread...hreadid=569151 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
usernames and passwords
answered early today
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "shannyshanhan" wrote in message news:shannyshanhan.2c6pnt_1154978714.7648@excelfor um-nospam.com... 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 I would like to think the people who answered my post. I have tried to apply what you told me and have had no luck. I am sure it is on my end as this is very new to me. Would one of you possibly be able to explain this to me in simpler terms for my simple mind? Thanks Shannon -- shannyshanhan ------------------------------------------------------------------------ shannyshanhan's Profile: http://www.excelforum.com/member.php...o&userid=37173 View this thread: http://www.excelforum.com/showthread...hreadid=569151 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
usernames and passwords
Shannon,
Take a look at the attached xls file it's the results of your sample data. Formulas should be fairly self explanitory. To walk you through it: Assumptions (based on your sample data): Full Name in column A Last Name in column B First Name in column C Username in column D Password in column E Row 1 is column header information Row 2 starts data series To create username enter this in D2 =LOWER(CONCATENATE((LEFT(C2,1),LEFT(B2,7))) It joins the first character in C2 with the first 7 of B2 into 1 string and then forcest everything lowercase To create password enter this in E2: =CONCATENATE(LOWER(LEFT(C2,1)),UPPER(LEFT(B2,1)),R ANDBETWEEN(100000,999999)) Again, working your way through the formatting, a string is created from the first character of C2 (first name) and forced to lower case the first character of B2 (last name) and forced to upper case A random number between 100000 and 999999. (I didn't want to have to deal with leading zeros) If you want to retain the record of the password, be sure to copy the resultant string and use Edit-Paste Sepcial to past the value of the password. If this is not done a new number will be generated for all areas where you have the password function whenever you do copy/paste functions. Hope this helps. Tom "shannyshanhan" wrote in message news:shannyshanhan.2c6pnt_1154978714.7648@excelfor um-nospam.com... 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 I would like to think the people who answered my post. I have tried to apply what you told me and have had no luck. I am sure it is on my end as this is very new to me. Would one of you possibly be able to explain this to me in simpler terms for my simple mind? Thanks Shannon -- shannyshanhan ------------------------------------------------------------------------ shannyshanhan's Profile: http://www.excelforum.com/member.php...o&userid=37173 View this thread: http://www.excelforum.com/showthread...hreadid=569151 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating username and passwords | Excel Worksheet Functions |