Hi,

Here is the basic idea for a LONG formula, how long depends on how long your
longest word can be.

=LOOKUP(MID(A1,1,1),$O$1:$O$26,$P$1:$P$26)&IF(LEN( A1)=2,LOOKUP(MID(A1,2,1),$O$1:$O$26,$P$1:$P$26)," ")&IF(LEN(A1)=3,LOOKUP(MID(A1,3,1),$O$1:$O$26,$P$ 1:$P$26),"")

This handles 3 letter word, just add another
&IF(LEN(A1)=3,LOOKUP(MID(A1,3,1),$O$1:$O$26,$P$1: $P$26),"") and change both
3's to 4's. Repeat this as many times as necessary.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


" wrote:

Hi,

Someone sent me one of those silly puzzles where the I need to
unscramble the word.

I want to solve this puzzle.
Cells A1 to L8 contains each one scrambled word.

cells O1:P26 have the alphabetical letter on the first column and
whatever I want on the second.

I need a formula on A15 that will take the word on A1 and replace all
the letters in the word using my key.

Suppose the letter in A1 is VI.
Suppose P22 for the letter V is T, for P9 for the letter I is O.
The result on cell A15 would then be TO.

I hope its clear.
Thanks