|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 17th 09, 09:03 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change the words from lower case to uppercase/capitals
I'd like to know the short cut keys to change the words I type from small
letters/lowercase to capital letters/uppercase. 
|
| Ads |
|
#2
July 17th 09, 09:11 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i change the words from lower case to uppercase/capitals
Use the below formulas
A1 = "text" 'convert to upper case B1 = UPPER(A1) 'convert to lower case B1 = LOWER(A1) 'convert to proper case B1 = PROPER(A1) If this post helps click Yes --------------- Jacob Skaria "dm" wrote: > I'd like to know the short cut keys to change the words I type from small > letters/lowercase to capital letters/uppercase.
|
|
#3
July 17th 09, 09:17 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i change the words from lower case to uppercase/capital
Another way is to use VBA. Right click the sheet tab>View Code and paste the
below code...Get back to workbook and try in that sheet..What ever you type in will turn to upper case... Private Sub Worksheet_Change(ByVal Target As Range) Target = UCase(Target) End Sub PS: If you dont find this working set the Security level to low/medium in (Tools|Macro|Security). and retry after restarting the application. If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: > Use the below formulas > > A1 = "text" > > 'convert to upper case > B1 = UPPER(A1) > > 'convert to lower case > B1 = LOWER(A1) > > 'convert to proper case > B1 = PROPER(A1) > > > If this post helps click Yes > --------------- > Jacob Skaria > > > "dm" wrote: > > > I'd like to know the short cut keys to change the words I type from small > > letters/lowercase to capital letters/uppercase.
|
|
#4
July 17th 09, 09:34 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i change the words from lower case to uppercase/capitals
Hi,
To do it as you type and to prevent any formula you type being converted to values try this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub Target.Formula = UCase(Target.Formula) End Sub Mike "dm" wrote: > I'd like to know the short cut keys to change the words I type from small > letters/lowercase to capital letters/uppercase.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot tables and grouping words that are both upper and lower case | Abdullah | Excel Worksheet Functions | 1 | May 4th 07 08:45 PM |
| Change the text from lower case to upper case in an Excel work boo | dave01968 | Excel Discussion (Misc queries) | 2 | December 9th 05 09:09 AM |
| How do I change a column in Excel from upper case to lower case? | Debbie Kennedy | Excel Worksheet Functions | 3 | May 2nd 05 06:57 PM |
| Change Capitals to Sentence Case | do | Excel Discussion (Misc queries) | 2 | March 29th 05 02:31 AM |
| How do I change existing text from lower case to upper case | CT Cameron | Excel Discussion (Misc queries) | 2 | November 30th 04 01:07 AM |
Linear Mode
