|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
07-18-2007, 10:32 PM
|
#1 |
|
Member (9 bit)
Join Date: Oct 2003
Location: NorthEastern USA
Posts: 369
|
MS Excel help
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
__________________
Fair isn't always equal. |
|
|
|
07-18-2007, 11:04 PM
|
#2 |
|
Member (9 bit)
Join Date: Dec 1999
Location: Il. USA
Posts: 288
|
the best free suite of excel macro utilities is here
http://www.asap-utilities.com/downlo...-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 |
|
|
|
|
07-19-2007, 07:28 AM
|
#3 |
|
Staff
Premium Member
Join Date: Jul 1999
Location: Arlington, TN
Posts: 5,538
|
Just create a simple formula. Excel has an UPPER function.
__________________
Want to Make $$$$ with your Computer? No Risk! Simply press shift-4 four times in a row |
|
|
|
|
07-20-2007, 08:54 AM
|
#4 |
|
Member (9 bit)
Join Date: Oct 2003
Location: NorthEastern USA
Posts: 369
|
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. |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Slow Cable Connection | Tokenekie | Networking & Online Security | 5 | 06-13-2007 10:20 AM |
| High Ping, Latency issue | SpectreT6 | Networking & Online Security | 6 | 02-23-2007 07:45 PM |
| Connects, but NO internet -Serious | lani | Networking & Online Security | 41 | 04-26-2005 09:53 AM |
| Why only me with IE? | rockabilly | Internet, Web Applications, & The Cloud | 13 | 09-29-2004 09:55 AM |
Linear Mode
