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