PH wrote...
Your A2 forumula works great, but the A3 formula only ever reponds
"none," and not the letter.

That's because I screwed up my A3 formula. It should be

=IF(LEN(A1)LEN(A2),RIGHT(A1,1),"none")