In MSWord, formatting can easily be set so that selected text is always in
capitals by FormatFontsAll 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.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=375201

Hi Joey,
You can use macros in Excel see
http://www.mvps.org/dmcritchie/excel...ars.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.
---
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

"MartinShort" wrote in message
...

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.

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

"MartinShort" wrote:


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.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=375201