software

hey all,

is there a way to select a range of cells and make the contents all lower
case?

thanks,
rodchar

rodchar -
Set up a dummy column and use the LOWER function as = LOWER(A1). Then
Copy gt; Paste Special gt; Values to convert that new column to values
only. Copy those over the original column and delete. If you need to
do this frequent, you'd need to write a half dozen lines of VBA.

- John Michlthank you.

quot;John Michlquot; wrote:

gt; rodchar -
gt; Set up a dummy column and use the LOWER function as = LOWER(A1). Then
gt; Copy gt; Paste Special gt; Values to convert that new column to values
gt; only. Copy those over the original column and delete. If you need to
gt; do this frequent, you'd need to write a half dozen lines of VBA.
gt;
gt; - John Michl
gt;
gt;

This is one of the standard features of the ASAP Utilities, a free Add-in
available at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3quot;rodcharquot; gt; wrote in message
...
gt; hey all,
gt;
gt; is there a way to select a range of cells and make the contents all lower
gt; case?
gt;
gt; thanks,
gt; rodchar
Hi rodchar,

Sub CHANGE_TO_LCASE()
'select range and run this to change to all CAPS
Dim cel As Range
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = LCase$(cel.Formula)
Next
End Sub

Which is a variation of Paul B's response to kristel, who only
yesterday needed to change an entire document to uppercase. I just
changed UCase$ to LCase$.
Ken Johnson