Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert ot upper case
how can i convert all text in excel spreadsheet to upper case?
|
#2
|
|||
|
|||
With a macro, to convert TEXT not formulas, first use Ctrl+A to
select all cells then run the macro at http://www.mvps.org/dmcritchie/excel/proper.htm#upper If you really must change ALL cells you can give the macro a different name and use "cells." instead of "selection." --- 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 "moe selectman" <moe wrote in message ... how can i convert all text in excel spreadsheet to upper case? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |