Format to lowercase

[Taylor]

Is there a way to format cells containing text in all caps so that they are
not in all caps?

 

[Dennis]

=LOWER(A1)

 

[Taylor]

Is there a way to do it without having to insert an additional column?

 

[David Biddulph]

LOWER, PROPER ?
But not by formatting.

 

[Dennis]

Copy the new column and then paste Special values only into your exsiting
column and then delete the additional column

 

[Gord Dibben]

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Lower()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = LCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

 

[Bill Sharpe]

Is there a way to format cells containing text in all caps so that they are
not in all caps?

You could download an all lower-case font.
See http://www.fontcenter.com/categories/Lower_Case_Only/index.html

Bill

 

[Harald Staff]

You could download an all lower-case font.
See http://www.fontcenter.com/categories/Lower_Case_Only/index.html

What a concept, Bill. We all think it can't be done by formatting, but this
is it, way outside the box. Thanks!!!

Best wishes Harald

 

[Bill Sharpe]

Fine as far as it goes, but remember that in such situations a
case-sensitive comparison with the lower case alternative would presumably
not succeed. You are presumably just seeing the upper case letters
*displayed* the same as lower case.

True enough, but the OP only asked about displaying the information, not
making comparisons. My own approach would be to make sure that entries
are made using a mix of upper and lower case as needed, but that's not
what was asked.

Bill