Thread
:
changing capslock letters into normal letters
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
changing capslock letters into normal letters
for each c in range("a2:a22")
c.value=lcase(c.value)
next c
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"mariekek5" wrote in message
...
Hi,
If I copy paste a certain file from a certain database into Excel, some
columns will contain data (text) with only capslock letters....
DOG
MONKEY
RABBIT
..etc
Is it possible to change this at once into 'normal' letters like:
dog
monkey
rabbit
.. etc
And is it possible to change it into 'normal' letters, starting with one
capital, like:
Dog
Monkey
Rabbit
...etc
Thanks a lot in advance.
Marieke
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett