I would like a FORMULA that change letters according to table of values that i make.



example:
êíöä = LOVE (because i made a table that show: ê=L, í=O, ö=V, ä=E).

example- Picture:


As you can see in the picture above,
AB1 - the word I want to decode.
AB2 - the end result that I want to get.
Note: The result is obtained by replacing all the letters in AB1 cell according to the table in A1:Z2.

Thank you. Appreciate your help..

Moved to the programming forum.
I'm afraid this cannot be done (easily) with formulas

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I thought of a way of finding a formula that find and replace letter, and then add to that "OR", for ALL letters. I tried something like this but without success...

If this is not possible then VBA would be pretty provides...

Any help would be appreciated ...

Do you have a worksheet you could attach to a post with some sample data? That would be easier to work with than a picture...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]