I need help creating all lower case usernames made up of the firs
letter of the customers first name and the first 7 letters of thei
last name.


I also need help creating passwords which will be made up of
customers first and last initial, followed by a random 6 digit number
the first character in the password will be lower case and the secon
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 t
apply what you told me and have had no luck. I am sure it is on my en
as this is very new to me. Would one of you possibly be able to explai
this to me in simpler terms for my simple mind?

Thanks
Shanno

--
shannyshanha
-----------------------------------------------------------------------
shannyshanhan's Profile: http://www.excelforum.com/member.php...fo&userid=3717
View this thread: http://www.excelforum.com/showthread.php?threadid=56914

This was answered this morning in worksheetfunctions

--

HTH

Bob Phillips

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

"shannyshanhan"
wrote in message
news:shannyshanhan.2c6pfj_1154978408.9225@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=569149