Password Table - Automatically Convert Text using a Table?

Hi,
I've created my own password table that allows me to, at the moment, manually take a memorable password and convert it into a string of letters, numbers and symbols.
I would like to be able to input my memorable password and for it to spit out my converted password. The table looks something like this:

a	b	c	A	B	C	1	2	3
1	c	2	C	B	A	3	b	a

Is there anyway I could get Excel to take a list of letters and numbers and use the above table to convert them?
e.g. if my password was A1b2C3, can I get excel to automatically convert it to --> C3cbAa ?
Thank you very much for your help,
Regards,
iaminneedofhelp

Hi iaminneedofhelp,

Here is an Example how to change a given Password to something new.
In this case we take the ASCII Value and add a specific Number to it to get a new password.

If you want the characters to change to a specific Value like in your Table you could make Arrays that are aligned with the Asci Numbers and fill them with the replacement chars

Please Login or Register  to view this content.

Greets Loki

problem if you randomize it this way is that you will not be able to reconstruct the Original Password cause you will end up with one Character having the same Value like another.

you could end up with a table for Hello that looks like this which makes it impossible to get the Original Password

H	e	l	l	o
Z	u	Z	Z	k

You defenetly get double values i testet your code with the given Example Sheet and i ended up with double values.
Even if you swap out numbers you do swap characters based on a rand number

Check my comments

Please Login or Register  to view this content.

Yes, LordLoki is correct.
What should I change the code to to fix this issue?
Thank you both very much for your help!

Is needing to recover the password from the output an absolute requirement? If not, why not just hash it?

Here is a solution that prevents the double assignment of Values
We Put all the Chars in a Collection then generate a number based on the items inside the Collection
assign the Char from the Collection to the table and delete it.

In this Scenario it could happen that for Example A still is A but that should not matter cause the chance that all letters stay the same is astronomically small :D

Please Login or Register  to view this content.

I've run the sub twice and both times I could not find any repeat values (maybe there are but I haven't noticed them yet).
Thank you both PJWhitfield and Lord Loki for helping me. I have combined both of your answers into one solution - much appreciated.
I have attached the final document for anybody interested to read.

P.S. Kyle, I don't know how to do my own cryptographic hashing yet!