Formula to help with picking part of cell data

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?

Try either of these formulas in Q3

=IF(COUNTIF(W3,"*G*"),"Y","")

or

=IF(ISERR(FIND("G",W3)),"","Y")

The second is case-sensitive the first one isn't