| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
uppar case
i want to know that if in excel sheet we type in small letter and we want to
make that all in capital letter how to do that regards, shekhar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
uppar case
If your text is in A1. In B1, type, =UPPER(A1) then copypaste
specialvalues. "shekhar" wrote in message ... i want to know that if in excel sheet we type in small letter and we want to make that all in capital letter how to do that regards, shekhar |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
uppar case
You can use a formula in another cell:
=upper(a1) shekhar wrote: i want to know that if in excel sheet we type in small letter and we want to make that all in capital letter how to do that regards, shekhar -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
uppar case
As you type...............
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column 2 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub Any cell you type into in columns A and B will be turned to UPPER case when you hit ENTER This is sheet event code. Right-click on the sheet tab and "View Code". Copy/paste the code into that module. Edit the range to suit. Gord Dibben MS Excel MVP On Mon, 11 Aug 2008 04:38:01 -0700, shekhar wrote: i want to know that if in excel sheet we type in small letter and we want to make that all in capital letter how to do that regards, shekhar |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
uppar case
Dear Gaurav ,
thanks a lot !!!!!! Shekhar "Gaurav" wrote: If your text is in A1. In B1, type, =UPPER(A1) then copypaste specialvalues. "shekhar" wrote in message ... i want to know that if in excel sheet we type in small letter and we want to make that all in capital letter how to do that regards, shekhar |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
uppar case
Dear Dave,
thanks a lot dear !!!!! Shekhar "Dave Peterson" wrote: You can use a formula in another cell: =upper(a1) shekhar wrote: i want to know that if in excel sheet we type in small letter and we want to make that all in capital letter how to do that regards, shekhar -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change from upper case to proper case in excel 2002 | Excel Discussion (Misc queries) | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Linear Mode
