Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change font from all capitals?
I have a spreadsheet from someone and it's all in CAPS. i want to change all
the font to lower case. Is there a way. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change font from all capitals?
See help on LOWER Function.
Or maybe PROPER function. Using functions you will need helper cells. If you want a macro to change all in place use this one. 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 Gord Dibben MS Excel MVP On Mon, 26 Apr 2010 14:48:01 -0700, jumbiegirl wrote: I have a spreadsheet from someone and it's all in CAPS. i want to change all the font to lower case. Is there a way. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change font from all capitals?
Uset the formula
=Lower(A1) -- HTH... Jim Thomlinson "jumbiegirl" wrote: I have a spreadsheet from someone and it's all in CAPS. i want to change all the font to lower case. Is there a way. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change font from all capitals?
Sub ChangeToLowerCae()
Dim lCap As Long For lCap = 65 To 90 ActiveSheet.UsedRange.Replace Chr(lCap), LCase(lCap) Next lCap End Sub -- Regards Dave Hawley www.ozgrid.com "jumbiegirl" wrote in message ... I have a spreadsheet from someone and it's all in CAPS. i want to change all the font to lower case. Is there a way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change current small text in a cell to CAPITALS? | Excel Discussion (Misc queries) | |||
how do i change the words from lower case to uppercase/capitals | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
change display font to actual selected font | Excel Discussion (Misc queries) | |||
Change Capitals to Sentence Case | Excel Discussion (Misc queries) |