How can I convert text to all lowercase?
 

How can I convert text to all lowercase?

I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?

If not with Excel, how about Word, DOS, any other way.

I'm using Excel 7.0 (Office 95).
Thanks in advance!

How can I convert text to all lowercase?
 

No need to multipost. See a couple of answers to your post in excel.misc

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------



"HBYardSale" wrote in message
...
How can I convert text to all lowercase?

I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?

If not with Excel, how about Word, DOS, any other way.

I'm using Excel 7.0 (Office 95).
Thanks in advance!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

How can I convert text to all lowercase?
 

Here is an example:

Sub teywutyu()
MsgBox UppCaseToLowCase("AdhsjakDsaLKJDs")
End Sub

Private Function UppCaseToLowCase(sString As String) As
String
Dim i As Long
Dim strTemp As String

strTemp = ""

For i = 1 To Len(sString)
strTemp = strTemp & LCase(Mid(sString, i, 1))
Next i

UppCaseToLowCase = strTemp

End Function

-----Original Message-----
How can I convert text to all lowercase?

I know that I can use the Format menu to convert a block
of text to all
uppercase, but is there any way to convert it to
lowercase?

If not with Excel, how about Word, DOS, any other way.

I'm using Excel 7.0 (Office 95).
Thanks in advance!

.

How can I convert text to all lowercase?
 

You mean with a macro?

Dim rng as Range, cell as Range
set rng = Activesheet.UsedRange.Specialcells(xlconstants,xlT extValues)
for each cell in rng
cell.Value = lcase(cell.Value)
Next
End Sub

--
Regards,
Tom Ogilvy

HBYardSale wrote in message
...
How can I convert text to all lowercase?

I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?

If not with Excel, how about Word, DOS, any other way.

I'm using Excel 7.0 (Office 95).
Thanks in advance!