Hi,

I have a cell which contains several letter e.g. G,W,P (cell W3) what i want to do is for the cell that im working in (Q3) to do an if statement (or another formula) to say if the letter g appears in cell W3, then populate the cell Q3 with the letter Y....

can anyone help?