G
Guest
how do I change lower case to upper case on a spreadsheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DL
Format cells?
S
ShopGirl
That option isn't available in format cells. You could use the formula
UPPER, but that would not change it in the same cell. It would put your word
in upper case in another cell of your choice.
There doesn't seem to be a way to do it in the cell itself.
UPPER, but that would not change it in the same cell. It would put your word
in upper case in another cell of your choice.
There doesn't seem to be a way to do it in the cell itself.
W
Wesley Vogel
Sample Macro Code to Change Case of Text (Excel 5.0, Excel 95, Excel 97)
http://support.microsoft.com/default.aspx?scid=kb;en-us;141094
XL2000: Sample Macro Code to Change Case of Text
http://support.microsoft.com/kb/213649/EN-US/
Excel 2002 Sample Macro Code to Change Case of Text
http://support.microsoft.com/kb/291323/EN-US/
--
Hope this helps. Let us know.
Wes
MS-MVP Windows Shell/User
In
http://support.microsoft.com/default.aspx?scid=kb;en-us;141094
XL2000: Sample Macro Code to Change Case of Text
http://support.microsoft.com/kb/213649/EN-US/
Excel 2002 Sample Macro Code to Change Case of Text
http://support.microsoft.com/kb/291323/EN-US/
--
Hope this helps. Let us know.
Wes
MS-MVP Windows Shell/User
In
B
Bert Kinney
Hi,
Go to the following site and download "Case Convert" and follow the
instructions to install the add-in.
http://www.cpearson.com/excel/download.htm
Are you familiar with Macros?
Go to the following site and download "Case Convert" and follow the
instructions to install the add-in.
http://www.cpearson.com/excel/download.htm
Are you familiar with Macros?
B
Bert Kinney
I should have added:
Place the add-in in the following folder.
C:\Documents and Settings\<User_name>\Application
Data\Microsoft\AddIns
Place the add-in in the following folder.
C:\Documents and Settings\<User_name>\Application
Data\Microsoft\AddIns
R
R. C. White
Hi, pjays.
See the article, "Demystifying Excel Macros", by Helen Bradley, on p. 60 of
the May 24, 2005, issue of PC magazine. She tells in detail how to write a
macro to change text in Excel to Upper, Lower or Proper Case.
Or online at: http://www.pcmag.com/article2/0,1759,1813366,00.asp
RC
See the article, "Demystifying Excel Macros", by Helen Bradley, on p. 60 of
the May 24, 2005, issue of PC magazine. She tells in detail how to write a
macro to change text in Excel to Upper, Lower or Proper Case.
Or online at: http://www.pcmag.com/article2/0,1759,1813366,00.asp
RC
G
Guest
Andrew Murray said:caps lock key?
Shift key?
if you mean something similar to "Change Case" in MS Word - there's no such
option
A
Andrew Murray
caps lock key?
Shift key?
if you mean something similar to "Change Case" in MS Word - there's no such
option
Shift key?
if you mean something similar to "Change Case" in MS Word - there's no such
option
W
Wesley Vogel
I've seen several of your posts. You ought to type something in the message
body, it makes it more interesting to read. ;-)
--
Hope this helps. Let us know.
Wes
MS-MVP Windows Shell/User
In
body, it makes it more interesting to read. ;-)
--
Hope this helps. Let us know.
Wes
MS-MVP Windows Shell/User
In
B
Bert Kinney
LOL...