Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change small letters to capital letters
dear sir/madam,
how to change small letters into capital letters or capital letters into small letters. regards, BALU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change small letters to capital letters
Check the Microsoft Excel help for the UPPER and LOWER functions.
Hope this helps. "HOW TO CHANGE" wrote: dear sir/madam, how to change small letters into capital letters or capital letters into small letters. regards, BALU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change small letters to capital letters
Hi Balu,
You may find several methods\free add-ins via google search and also check back later for your post. To find within excel, you may download Google search addins by Ron from below site. http://www.rondebruin.nl/Google.htm BTW in case you want to use addins, you may download my free com-addins "change cell case" from below site http://in.geocities.com/shahshaileshs/ Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Excel Add-ins Page) "HOW TO CHANGE" wrote: dear sir/madam, how to change small letters into capital letters or capital letters into small letters. regards, BALU |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change small letters to capital letters
Hi Balu,
formula: to change from capital letters to small letters =lower() to change from small letters to capital letters =upper() (put the cell in the () e.g. =lower(A1) Austuni "HOW TO CHANGE" wrote: dear sir/madam, how to change small letters into capital letters or capital letters into small letters. regards, BALU |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change small letters to capital letters
Hi
In addition to the responses you have already received, don't forget =PROPER(A1) which would change "this" to "This" -- Regards Roger Govier "HOW TO CHANGE" <HOW TO wrote in message ... dear sir/madam, how to change small letters into capital letters or capital letters into small letters. regards, BALU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i turn all letters into capital letters? | Excel Discussion (Misc queries) | |||
how to change existing column to capital letters | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
How do I change a column of cells to all capital letters? | Excel Worksheet Functions | |||
Auto change font to 'capital letters' | Excel Worksheet Functions |