L lydia Jul 21, 2004 #1 i need to change the case in a string of entries (a2:a35). how do i use the upper function?
G Guest Jul 21, 2004 #3 thanx! -----Original Message----- In B2 enter & copy down: =UPPER(A2) . Click to expand...