Text All Capitals

[Joey]

In MSWord, formatting can easily be set so that selected text is always in
capitals by Format>Fonts>All Caps.

Can text in Excel be similarly formatted?

 

[MartinShort]

Yes it can be done, but not quite in the same way that Word works.

Assuming Column A (ie A1, A2, A3 etc) contains the data you wish to
converted to upper case, choose a parallel Column B (ie B1, B2, B3
etc.) and use the formula =UPPER(A1)
=UPPER(A2)
=UPPER(A3)
and so on.

 

[David McRitchie]

Hi Joey,
You can use macros in Excel see
http://www.mvps.org/dmcritchie/excel/toolbars.htm#macros

You can use the upper_case macro to convert existing entries
in a selection. Then you install the change event macro to a
specific sheet customized to convert entries to a specific column
upon entry (change event). You would be installing two different
kinds of macros as described in the text.

 

[bigwheel]

Take a look here http://www.cpearson.com/excel/download.htm