changing text to upper case in excel 97 worksheet


Posted by karen on August 24, 2001 9:53 AM

I need to change the lower case text to upper case text in several cells.
How can this be done?



Posted by Barrie Davidson on August 24, 2001 9:54 AM

Use the UPPER function,
=UPPER(A1)

Barrie