[mso] Re: Upper and Lower Case
- From: "Pam" <ltf01@xxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 21 Oct 2003 15:39:05 -0500
Thanks Ray and Linda. What I am remembering sounds like what Ray described.
I have to enter name, city, and state, into an Excel sheet, in all upper
case, and when I stop to toggle back and forth with other apps it causes me
to need to retype stuff because I forgot to change the case. I'm thinking
that the =UPPER is going to be the solution so that I don't have to toggle
back and forth manually.
Thanks again both of you.
Pam
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Linda F. Johnson
Sent: Tuesday, October 21, 2003 3:14 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Upper and Lower Case
In Excel, you have to use formulas to do this, Pam
Let's say the text you want to create is in cell A1
=UPPER(A1) ... would put it all in caps
=LOWER(A1) ... would lower case it all
=PROPER(A1) ... would cap the first letter of each word
No keystroke for this in Excel...remember Word is for words, Excel is mostly
for numbers, so it has less features for text editing.
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Pam
Sent: Tuesday, October 21, 2003 4:05 PM
To: MicrosoftOffice
Subject: [mso] Upper and Lower Case
I remember reading somewhere about keystrokes that could capitalize all
letters, or make lower case out of all letters, or capitalize first letters
only. I thought I saved it but I can't find it. Where I want to use this
feature now is in Excel, but I was thinking that this keystroke thing was
for Word or Excel. Does this sound familiar to anyone, and is there such an
ability?
Pam
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
