PS with all these methods how do you find in the VB help the various
options in your StrConv(nm.Value, vbProperCase) ? Or is their a decent
manual somwehere? I would much prefer being able to find it myself rather
than bother you guys!
Thanks again!
Mervyn

"Mervyn Thomas" wrote in message
...
I particularly liked this solution but thanks to everyone who answered
"JLGWhiz" wrote in message
...
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = Next

End Sub


"Mervyn Thomas" wrote in message
...
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?