Big Letters

[Loi]

Hi,
I have two column D and E. All data entered in small
letters.(lower case)
Please show me how to make them all become big letters
(Upper case).

Thank You
Loi

 

[Ramakrishnan Rajamani]

Use the function =UPPER and it will work.

 

[Ramakrishnan Rajamani]

In case you want to capitalize the first letters in each
word, use the =PROPER function.

 

[David McRitchie]

I would suggest you use a macro then you can work with a selection.
http://www.mvps.org/dmcritchie/excel/proper.htm#upper
Reference at top for installing and using macros can be found at
http://www.mvps.org/dmcritchie/excel/getstarted.htm