MS Excel help

[ThePoor]

Hi all,

I have a worksheet already has data on it and I like to make all to upper case. How should this be done?

Thank you in advance,

Monday Tuesday Wednesday Thursday Friday
1st Wave Alvarez Welk Shaskan Horesco Ryan
Welk Andreo Guzman Svoboda Glowa

10:41 - 11:11 ROOMS: 114,407,410,504,507,509 = 116

2nd Wave A.Boutilier Maleszeska Nguyen Cone Brady
Brady Colon L.Boutilier Galotti Brescia

11:25 - 11:55 ROOMS: 110,202,203,310,409,503 = 110

3rd Wave Schmidt Rivera Bermudez Michaels Nyquist
N.Barlowski Finkenstein Rivera-Medina Beebe Taraskewicz

[stylin19]

the best free suite of excel macro utilities is here

http://www.asap-utilities.com/download-asap-utilities.php


with the text utility
you can select the entire worksheet and change the case on the fly


these have worked well for me
ghood luck

[mairving]

Just create a simple formula. Excel has an UPPER function (http://www.bettersolutions.com/excel/EDH113/QP510412322.htm).

[ThePoor]

Thank you Stylin19, the addin works great.

My new question:
For example: I have the following data:

70
70
80
50
60
85

How to I calculate the percentage of data that greater than or equal to 70?

Thank you in advance for all your help.