Changing from ALL CAPS

[John Toner]

Good Morning! Well it happens - I forgot. I remember
there is a way to change a field from ALL CAPS - to Upper
and low case.

 

[Frank Kabel]

Hi John
try
=PROPER(A1)

 

[David McRitchie]

or to change the cell content itself and be done with it, you need a macro
http://www.mvps.org/dmcritchie/excel/proper.htm

 

[John]

Thank you so Much!!

-----Original Message-----
Hi John
try
=PROPER(A1)

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Don Guillett]

Here's one you might like.
Sub ChangeCase()
Application.ScreenUpdating = False
Dim r As Range
nCase = UCase(InputBox("Enter U for UPPER" & Chr$(13) & " L for
lower" & Chr$(13) & " Or " & Chr$(13) & " P for Proper", "Select
Case Desired"))
Select Case nCase
Case "L"
For Each r In Selection.Cells
If r.HasFormula Then
r.Formula = LCase(r.Formula)
'R.Formula = R.Value
Else
r.Value = LCase(r.Value)
End If
Next

Case "U"
For Each r In Selection.Cells
If r.HasFormula Then
r.Formula = UCase(r.Formula)
'R.Formula = R.Value
Else
r.Value = UCase(r.Value)
End If
Next
Case "P"

For Each r In Selection.Cells
If r.HasFormula Then
r.Formula = Application.Proper(r.Formula)
'R.Formula = R.Value
Else
r.Value = StrConv(r.Value, vbProperCase)
End If
Next
End Select
Application.ScreenUpdating = True
End Sub