usernames and passwords

[shannyshanhan]

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

[Bob Phillips]

answered early today

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"shannyshanhan" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Thomas Homan]

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)),RANDBETWEEN(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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>