Generating random number string based on Alphanumeric String

Hi All,

Wondering if it is possible to generate a random 4 digit number based off an alphanumeric string?

Example;

Cell A1 has 123XVF1234
Cell A2 has 321AFW4321

In B1 I would like to have a 4-6 digit number that is generated based on the alphanumeric data in Cell A1 (and so on down the list). If that is possible, I would also need to be able to convert back the 4-6 digit number back to its original alphanumeric value

Example;

If B1 returns 643562 it would need to be able to be converted back to 123XVF1234

Any help or direction would be appreciated.

Thanks for the reply, let me change my terminology from "Random" to "Predictable" then. Since each alphanumeric string will be different, each "predictable" number that is generated should be different.

I would like a max of 4-6 digits ideally, I guess if it is the same length it is a start??

OK so I gave that a try and this is what I get (i input and highlighted the formulas above so you could see what is applied);

Untitled.jpg

Not sure if this is the intention, can you provide some more detail on how this is supposed to work relating to my issue? I can see it is converting it but I don't end up with a 4-6 digit number (I need number only, not alpha numeric) and I don't see how I can convert that number back to its original value?

Thanks again for the support.