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!
|