View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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!