Thread: Find and replace multiple values, according to table value - excel formula
View Single Post
 
Old 04-10-2016, 03:55 AM
EtanM EtanM is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Dec 2013
Posts: 3
EtanM is on a distinguished road
Default Find and replace multiple values, according to table value - excel formula
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..
Reply With Quote