Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can you change an Excel spreadsheet from a combination od Upp.
I want ot change a Excel speadsheet from a combination of upper and lower
case to all uppercase ie all 'Capitols'. Thanks |
#2
|
|||
|
|||
Try the UPPER function.
If you want to do it programmatically, you will need a macro. -- Regards, Fred Please reply to newsgroup, not e-mail "AllenH" wrote in message ... I want ot change a Excel speadsheet from a combination of upper and lower case to all uppercase ie all 'Capitols'. Thanks |
#3
|
|||
|
|||
Take a look he
http://www.mvps.org/dmcritchie/excel/proper.htm#upper In article , AllenH wrote: I want ot change a Excel speadsheet from a combination of upper and lower case to all uppercase ie all 'Capitols'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting an excel spreadsheet on a web page | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Excel should have a quick and simple "change case" function like . | Excel Worksheet Functions | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
How do I stop Macros from opening with every excel spreadsheet? | Excel Discussion (Misc queries) |