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