Text All Capitals

  • Thread starter Thread starter Joey
  • Start date Start date
J

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?
 
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.
 
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.
 
Back
Top