to find and replace multiple entries

Dear All,

I would like to search for numbers and replace them with text (multiple entries).

I tried doing this with vlookup, but for some reasons i dont get the good values.
Can somebody help me?

thanks in advance
K

How many replacements need to be made? By the looks of your example there are only 5 (5 different numbers to be replaced with A through E). If that is the case a very simple solution would be to use Excel's built in Replace function. Simply open your worksheet and push Ctrl+F. This will open Find; at the top of this window there is a tab for Replace. Type in the number you want to replace in the first field, type in the letter you with to replace it with in the second field, click replace all. Repeat for all 5 letters. Shouldn't take more than a minute if its just the five...

...or am I misunderstanding what you are trying to do...?

Dear Alkey,

Is this best way to do find and replace long list numbers ? do you have any other solutions?
Thank you very much. It works now. What does the "0" do?

Is there anyway to take the adjacent column values also?
what i mean is, after vlookup, (right now it puts only the one row which is specified as 2 (in this case))
is there a possibility to take adjacent column 2,3 and 5 as well?
It would great to know solution for such thing.
Thanks again for your time

regards
K


Dear prjt, I have a long list of numbers to be replaced in a long list of sheet which runs for 900 rows. That is why i am looking for quick way to do it.

Dear Alkey,

Thanks for your comments.

regards
K