![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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.. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Need assistance to find and replace text within headers/footers in excel - multiple worksheets
|
teddycatnc | Excel | 3 | 03-07-2016 12:04 AM |
IF Formula - multiple values
|
Jac_Fcb | Excel | 1 | 03-17-2015 12:41 AM |
| find 2 values i a table to find the right prise | Vibov | Excel | 1 | 01-11-2015 07:25 AM |
| Find and Replace multiple table columns | smakdown61 | Word | 1 | 08-28-2014 09:24 PM |