Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-10-2016, 03:55 AM
EtanM EtanM is offline Find and replace multiple values, according to table value - excel formula Windows 7 32bit Find and replace multiple values, according to table value - excel formula Office 2010 32bit
Novice
Find and replace multiple values, according to table value - excel formula
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace multiple values, according to table value - excel formula Need assistance to find and replace text within headers/footers in excel - multiple worksheets teddycatnc Excel 3 03-07-2016 12:04 AM
Find and replace multiple values, according to table value - excel formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft