how to do if small letter change to capital letter?
M Max Oct 2, 2007 #2 In B1: =UPPER(A1) will change lower case text in A1 to upper case Copy B1 down as needed.
