PC Review


Reply
Thread Tools Rate Thread

"Change Case" function missing?

 
 
Sigi Rindler
Guest
Posts: n/a
 
      25th Nov 2006
I had to translate part lists in Excel (lower case letters). Now I was told
to change them all to upper case letters. Where does Excel 2003 have this
function?
Right now I need to copy consecutive blocks of text into MS Word, change the
case, then copy these files back into Excel...
I hope that this is possible since I seem to get these kind of work
continuously. Typing in upper case letters is no fun and it's hard to read.

Thanks,
Murgi



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      25th Nov 2006
Look in HELP for the UPPER() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sigi Rindler" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
|I had to translate part lists in Excel (lower case letters). Now I was told
| to change them all to upper case letters. Where does Excel 2003 have this
| function?
| Right now I need to copy consecutive blocks of text into MS Word, change the
| case, then copy these files back into Excel...
| I hope that this is possible since I seem to get these kind of work
| continuously. Typing in upper case letters is no fun and it's hard to read.
|
| Thanks,
| Murgi
|
|
|
| ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
| http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
| ----= East and West-Coast Server Farms - Total Privacy via Encryption =----


 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      25th Nov 2006

A trip to the help files index for CASE would have been so easy.
--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Sigi Rindler" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I had to translate part lists in Excel (lower case letters). Now I was told
>to change them all to upper case letters. Where does Excel 2003 have this
>function?
> Right now I need to copy consecutive blocks of text into MS Word, change
> the case, then copy these files back into Excel...
> I hope that this is possible since I seem to get these kind of work
> continuously. Typing in upper case letters is no fun and it's hard to
> read.
>
> Thanks,
> Murgi
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
> News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
> Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----



 
Reply With Quote
 
 
 
Reply

Thread Tools
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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I count only lower case "x" and exclude upper case "X" =?Utf-8?B?amJlbGV0eg==?= Microsoft Excel Worksheet Functions 3 14th Oct 2006 10:50 PM
How do I find the "case" function in Excel 2007 ? =?Utf-8?B?RHIgQWxvayBNb2RpIE1E?= Microsoft Excel Misc 5 22nd Jul 2006 04:53 AM
Use "PROPER" to change UPPERCASE text to Title Case on worksheet =?Utf-8?B?Y211cmRvY2s=?= Microsoft Excel Worksheet Functions 1 31st Jan 2006 11:19 PM
The function "print"is missing under "file"key, =?Utf-8?B?QU1OT04=?= Microsoft Word Document Management 1 11th Jul 2005 11:19 PM
Excel should have a quick and simple "change case" function like . =?Utf-8?B?TmluYVN2ZW5kc2Vu?= Microsoft Excel Worksheet Functions 1 28th Jan 2005 03:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:15 AM.