Format Excel column as Upper Case without use of UPPERCASE formul
 

In Word a table column can be set to display in Upper Case regardless of case
in use during input. Is this available in Excel? The formula UPPERCASE
wastes a column and adds unnecessary complications.

Format Excel column as Upper Case without use of UPPERCASE formul
 

Excel has no "uppercase view" of a font. But there are macros that can
change the case to uppercase either all at once or during data entry.
http://www.officearticles.com/excel/...ft_exce l.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

"Trickywoo" wrote in message
...
In Word a table column can be set to display in Upper Case regardless of
case
in use during input. Is this available in Excel? The formula UPPERCASE
wastes a column and adds unnecessary complications.