Cenerate password from cell information

[n2brand]

I have a spreadsheet with my customers , name ,address, phone number, height , weight , etc.
I would like to generate a unique random password for each customer using 3 or more of their cells information.

Thank you in advance

 

[braindiesel]

To get you started, you can use formulas to create what the password will be.
If A1 = NAME
A2 = ADDRESS
A3 = PHONE

the formula =LEFT(A1,2)&MID(A2,2,3)&RIGHT(A3,3) would produce the value NADDRONE
left(A1,2) = NA - Left 2 characters
MID(A2,2,3) = DDR - Middle 3 characters starting at the 2nd character
RIGHT(A3,3) = ONE - Right 3 characters

You can adjust that as required for whatever targets you wish.

Was that the end of your issue? or did you want to apply that password?
Assuming the latter... where... password to open sheet? Password to unlock sheet?
Please confirm

 

[n2brand]

That works well. Is there a way to make some of it a mixture of letters, number and characters ?

Makes for a little more secure.

Yes also to open separate sheet.

Thank for your quick response

 

[braindiesel]

You are creating a text string so yes to the mixture of letters and numbers
If the right one for instance was pointed at a phone number and the last three digits were 123 the answer would have been NADDR123

You can also add case sensitivity
Teweaking my original example

If A1 = NAME
A2 = ADDRESS
A3 = 4165551212

the formula =LEFT(A1,2)&LOWER(MID(A2,2,3))&RIGHT(A3,3) would produce the value NAddr212
LEFT(A1,2) = NA - Left 2 characters
MID(A2,2,3) = ddr - Middle 3 characters starting at the 2nd character all converfted to LOWER case
RIGHT(A3,3) = 212- Right 3 characters

PUT LOWER( ) around your formula segment to make it lower case. UPPER makes it upper case and PROPER capatalizes the first Character of the string

 

[n2brand]

That's great and how would I apply it to open their individual sheet ?

Thans again

 

[braindiesel]

Sheets("Sheet1").Protect Password:="myPassword"

Change "Sheet1" to relevant sheet name

assuming the password you want to apply is on sheet "MWAHAHA" in cell B2
and replace "myPassword" with Sheets("MWAHAHA").Range("B2).value

Sheets("Sheet1").Protect Password:=Sheets("MWAHAHA").Range("B2).value

That should do it

 

[n2brand]

That's awesome. I will work with this and if I have issues I will ask more questions..

I really appreciate your time ,

 

[n2brand]

How would I structure the formula if I wanted to use 4,5,or 6 columns to generate the password ?

 

[braindiesel]

Look at my original formula. the & (ampersand) symbol is like the nub on a lego block... it connects cells together.
So=A1&A2&A3&B4&F5&C2.... as many pieces as you wish

 

[n2brand]

Got it .Again Thank you !