Capitalization


Posted by Ruth Cullen on February 06, 2002 4:13 PM

Is there a way to change a large range of text from small letters to capital letters?

Posted by Jack in the UK on February 06, 2002 4:20 PM

Try UPPER(range) but will need to insert column =UPPER($A1) and drag down copy paste as values and delete not required. [NT]



Posted by anno on February 06, 2002 4:51 PM

should that formula be =UPPER(A1) ? [nt]