changing capslock letters into normal letters
=LOWER(A1) to change to lower case
=PROPER(A1) to change to proper case ( only first letter cap'ed)
--
Gary''s Student - gsnu200858
"mariekek5" wrote:
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
|