Capitalization

S

sgtbob

I may have asked this before, but can't locate a response.

After I have entered data in 'lowercase' how can I change the entrie
to 'UPPERCASE', without re-typing everything? Word has a feature t
change cases, but I am unable to find this feature in Excel.

Please advise.

sgtbob :confuse
 
M

Myrna Larson

There's no corresponding feature in Excel. You can use the UPPER function in a
formula in another cell. Used Edit/Copy, then Edit/Paste Special, Values to
convert the formulas to literal text.
 
J

jallen1788

my only suggestion would be to use the UPPER function in excel. th
syntax is as follows:

=UPPER(A1)

reference A1 to A1 of the 'lowercase' sheet
create a new sheet with this formula in cell A1, then copy the formul
onto all other cells.

basically now youll have an uppercase copy of the lowercase sheet, wit
all cells referenced to the lowercase sheet
 
B

Bob Phillips

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:A100")) Is Nothing Then
With Target
.Value = UCase(.Value)
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
 
Top