Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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?

Re: changing text to upper case in excel 97 worksheet

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

Use the UPPER function,
=UPPER(A1)

Barrie


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.