Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to distinguish uppercase from lowercase text? | Excel Discussion (Misc queries) | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
How can I cange text to lowercase in Excel | Excel Discussion (Misc queries) | |||
Lowercase text changed by Ecel to Uppercase after import | Excel Discussion (Misc queries) | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions |