Hi,

Here is a formula approach:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,LEFT(A1),LOOK UP(LEFT(A1),C1:C26,D1:D26)),MID(A1,2,1),LOOKUP(MID (A1,2,1),C1:C26,D1:D26)),RIGHT(A1),LOOKUP(RIGHT(A1 ),C1:C26,D1:D26))

I used the range C1:C26 and D1:D26 you should adjust those for you column O:P.

--
Thanks,
Shane Devenshire


" wrote:

Hi,

Is there a way to substitute letters from a word in a cell, with
predifined letters for the whole word?

Cell A1 contains the word. OLE.
Cells O1:O26 have the letters of the alphabet and cells P1:P26 have
the replacement letter.

I need a formula on cell A15 that will take the word OLE in cell A1
and replace all those letters with its match on cells P1:P26.

Thanks