Random Passphrase Formula or VBA

[krisso]

Is there a way to generate a passphrase from a cell value either by formula or VBA. I have done a search this morning and cant find anything that fits what I would like. The cell value will be alphanumeric if this makes any difference

Thanks
Chris

 

[wideboydixon]

You could generate a basic hash using the contents of the cell like this but I'm not sure if it's quite what you're after:

Book1
	A	B
1	Text	Hash
2	Wide Boy Dixon	5C7D840
3	krisso	5456A1
4	Mr. Excel Forum	79791E4
5	Random Passphrase Formula or VBA	8365DA40
6	wideboydixon	4542964
Sheet1

Cell Formulas
Range	Formula
B2	{=DEC2HEX(SUM(CODE(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1))*ROW(INDIRECT("1:"&LEN($A2))))^2)}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD

 

[krisso]

Thanks for this WBD, I was looking for a random generation of the cell value so if for example A1 was Wideboydixon200180 then I would get a random value using these characters and numbers but your suggestion is one that if I am honest didnt even know about. So may work for what I need