G Guest Oct 2, 2007 #2 In B1: =UPPER(A1) will change lower case text in A1 to upper case Copy B1 down as needed.
