Dear everyone;

I am after a function, which could work out the inverse of a letter:

Dim a as string

a b c d e f
A = F E D C B A

Now the inverse would be F E D C B A

The inverse is worked out by working out the inverses of the substitution, for example the inverse of E would be B, the Inverse of A would be F, the inverse of C would be D.

Can anyone please help me find a function, I was told a mid function could be used. Do we need a loop, please please me with the code, I will be able to do the rest, please show me some example of working code

While that method works, he/she had mentioned the use of mid..... which is why I steered away from the strreverse function.... well done, however.

Hello thank you very much, but what i needed is the inverse for example if i have the following letters:

ABCDEF G HIJKLMNOPQRSTUVWXYZ
BDFHJL C PRTXVZNYEIWGAKMUSQO

the inverse effect would be:

ABCD E FGHIJKLMNOPQRSTUVWXYZ
TAGB P CSDQEUFVNZHYIXJWLRKOM

i have done the rest, i just need an example how i can do this, please help

Hi,
Not too sure I understand what you are after.

If the input is:
ABCDEF G HIJKLMNOPQRSTUVWXYZ

should the output be...
ZYXWVU T SRQPONMLKJIHGFEDCBA
or
ZYXWVUTSRQPONMLKJIH G FEDCBA
or ????

If inverse, means backwards, which I'm pretty sure it does (unless you mean a literal xor of the ascii values, which, clearly you don't) then both examples that we have provide suffice.

This article has been dead for over six months. Start a new discussion instead.