Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 07-18-2007, 10:32 PM   #1
Member (9 bit)
 
ThePoor's Avatar
 
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.
ThePoor is offline   Reply With Quote
Old 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
stylin19 is offline   Reply With Quote
Old 07-19-2007, 07:28 AM   #3
Staff
Premium Member
 
mairving's Avatar
 
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
mairving is offline   Reply With Quote
Old 07-20-2007, 08:54 AM   #4
Member (9 bit)
 
ThePoor's Avatar
 
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.
ThePoor is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -5. The time now is 12:12 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2