Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
see a similar thread in this newsgroup:
http://groups.google.com/groups?thre...GP15.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" wrote in message ... CHANGE ALL TEXT IN A SPREAD SHEET FROM LOWER CASE TO UPPER CASE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert an entire spread sheet form inches to mills. | Excel Discussion (Misc queries) | |||
How do I convert an entire spread sheet form inches to centimeters | Excel Discussion (Misc queries) | |||
how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) | |||
Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
How do I change the font color of my sheet tabs? | Excel Discussion (Misc queries) |