HOW DO YOU CHANGE AN ENTIRE SPREAD SHEET FROM LOWER CASE TO UPPER

CHANGE ALL TEXT IN A SPREAD SHEET FROM LOWER CASE TO UPPER CASE

The easiest, non-programmatic way to do this would be to add another sheet to
the existing workbook, place =UPPER(Sheet_With_LowerCase!A1) and copy this
formula throughout the entire range of the sheet, matching the range of the
Sheet that contains the lowercase text. You could then copy and paste
special as values. Programmatically, this would be much easier to do.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"DRPATRICK2" wrote:

> CHANGE ALL TEXT IN A SPREAD SHEET FROM LOWER CASE TO UPPER CASE

see a similar thread in this newsgroup:
http://groups.google.com/groups?thre...TNGP15.phx.gbl

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DRPATRICK2" <DRPATRICK2@discussions.microsoft.com> wrote in message news:356621DA-BCBD-4029-9C8C-A273E0991938@microsoft.com...
> CHANGE ALL TEXT IN A SPREAD SHEET FROM LOWER CASE TO UPPER CASE