lower case - UPPER CASE

[Andrew]

I want to convert some cells containing lower case letters
to upper case without re-typing the whole lot. Any ideas?

: )

Andrew

 

[Paul B]

Andrew, here is one way, with your data in column A, put this in B1 and
copy down =UPPER(A1), then copy and paste valves over your data

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Dave]

use +upper(a1)

 

[J.E. McGimpsey]

First idea - PLEASE DON'T! ALL UPPER CASE IS MUCH HARDER TO READ
THAN lower case, Mixed case or Proper Case.

But if you insist, check out David McRitchie's macro to convert in
place:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper