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.

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/...soft_excel.htm

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

"Trickywoo" <[email protected]> wrote in message
news:[email protected]...
> 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.