Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Substitute letters by others in a word
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup using partial word, first 4 letters | Excel Worksheet Functions | |||
how do I reduce the spaces between letters in a word? | Excel Discussion (Misc queries) | |||
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
How do you sort words in Excel by the number of letters in a word | New Users to Excel |