Use Data Validation to force user to input uppercase
But, Excel is not case sensitive so =IF(A1="Y", Dothis, Dothat) will give
DoThis for A1 = Y or y
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jhg1226" wrote in message
...
In Excel I have a column which asks for a Y or N response. If the user
inputs y or n in lower case Can I have Excel convert it to Upper Case?