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
Niek Otten - 25 Nov 2006 09:31 GMT
Look in HELP for the UPPER() function

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
|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
[quoted text clipped - 10 lines]
| http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
| ----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Don Guillett - 25 Nov 2006 13:06 GMT
A trip to the help files index for CASE would have been so easy.

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>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
[quoted text clipped - 14 lines]
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----