I have a series of "Yes" answers in my spreadsheet represented with a "Y". I
want the "y" to automatically capitalize. I set up an auto correct, but it
doesn't captialize all of my "y"s and it's also not doing it consistently. I
can go back into a cell that capitalized once and try it again and it doesn't
work (or vice versa).

Help!