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

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

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

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

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

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