Hi

I have the following data:

Excel Data.JPG

What I would like to do is have a formula that will take any cell with A to D letters and replace them with associated word in the same row. For example, For C2 and D2 I would like them to be changed to Drew, and for B3 to be changed to limp. I would like this to be done on a larger scale so would like it to be easy and not have many steps, hopefully one formula to cover it.

Many thanks - I hope someone can assist with this.

Drew.