Prev: updating with now()
Next: Identifying a Pivot Table
From: Mervyn Thomas on 22 Dec 2009 11:24
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?


From: p45cal on 22 Dec 2009 12:02

Mervyn Thomas;593677 Wrote:
> Does anyone have a bit of code to convert a file of conatcts all in
> UPPERCASE to Lower Case?

Code:
--------------------
For each cll in selection.cells
cll.value = lcase(cll.value)' either this line or the next
'cll.Value = Application.WorksheetFunction.Proper(cll.Value)
next cll
--------------------


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=164484

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

From: JLGWhiz on 22 Dec 2009 12:05
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = StrConv(nm.Value, vbProperCase)
Next

End Sub


"Mervyn Thomas" <mervyn-thomas(a)ntlworld.com> wrote in message
news:Ao6Ym.1125$Hy7.328(a)newsfe06.ams2...
> Does anyone have a bit of code to convert a file of conatcts all in
> UPPERCASE to Lower Case?
>


From: Ryan H on 22 Dec 2009 12:14
Use the LCase Function.

LCase("Your String Here")

Hope this helps! IF so, let me know, click "YES" below.
--
Cheers,
Ryan


"Mervyn Thomas" wrote:

> Does anyone have a bit of code to convert a file of conatcts all in
> UPPERCASE to Lower Case?
>
>
> .
>
From: Gord Dibben on 22 Dec 2009 12:15
"Lower Case" looks like Proper Case to me.

You choose.................

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



On Tue, 22 Dec 2009 16:24:00 -0000, "Mervyn Thomas"
<mervyn-thomas(a)ntlworld.com> wrote:

>Does anyone have a bit of code to convert a file of conatcts all in
>UPPERCASE to Lower Case?
>

 |  Next  |  Last
Pages: 1 2 3
Prev: updating with now()
Next: Identifying a Pivot Table