Prev: select all non-blank cells
Next: select all non-blank cells from different workbook
From: Prashant on 6 May 2010 11:49
Hi All,

Need your help!!!

I need a setting/formula/Coding in such a way that whatever text I type in
sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.

I checked settings but did not find anything helpful.

Thanks in advance for your assistance!!!

Prashant.
From: Sasikiran on 6 May 2010 11:54
Dear Prashant,

Use =UPPER() formula

A1 prasanth B1 =UPPER(A1)


"Prashant" wrote:

> Hi All,
>
> Need your help!!!
>
> I need a setting/formula/Coding in such a way that whatever text I type in
> sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.
>
> I checked settings but did not find anything helpful.
>
> Thanks in advance for your assistance!!!
>
> Prashant.
From: Brad on 6 May 2010 12:05
The only way that I know can change the information is the same cell you type
it in is using a macro. This macro is relatively easy - this maco is located
in the microsoft Excel object section - on the sheet that you want to change.

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Value = UCase(Target.Value)
End Sub

If you never have written a macro - "Google" is a good resourse - as well as
this site.
--
Wag more, bark less


"Prashant" wrote:

> Hi All,
>
> Need your help!!!
>
> I need a setting/formula/Coding in such a way that whatever text I type in
> sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.
>
> I checked settings but did not find anything helpful.
>
> Thanks in advance for your assistance!!!
>
> Prashant.
From: Jacob Skaria on 6 May 2010 12:06
I understand you are try to convert this automatically as you type in to
Sheet1. Select the sheet tab which you want to work with. Right click the
sheet tab and click on 'View Code'. This will launch VBE. Paste the below
code to the right blank portion. Get back to to workbook and try out.


Private Sub Worksheet_Change(ByVal Target As Range)
If Target <> "" Then
If Not Target.HasFormula Then Target = UCase(Target.Value)
End If
End Sub


--
Jacob (MVP - Excel)


"Prashant" wrote:

> Hi All,
>
> Need your help!!!
>
> I need a setting/formula/Coding in such a way that whatever text I type in
> sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.
>
> I checked settings but did not find anything helpful.
>
> Thanks in advance for your assistance!!!
>
> Prashant.
From: Brad on 6 May 2010 12:09
Your suggestion will work but will require two cells one for the OP to enter
the information and another to change it to caps - as I'm sure you are well
aware of.

"Sasikiran" wrote:

> Dear Prashant,
>
> Use =UPPER() formula
>
> A1 prasanth B1 =UPPER(A1)
>
>
> "Prashant" wrote:
>
> > Hi All,
> >
> > Need your help!!!
> >
> > I need a setting/formula/Coding in such a way that whatever text I type in
> > sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.
> >
> > I checked settings but did not find anything helpful.
> >
> > Thanks in advance for your assistance!!!
> >
> > Prashant.
 |  Next  |  Last
Pages: 1 2
Prev: select all non-blank cells
Next: select all non-blank cells from different workbook