changing capslock letters into normal letters
See help on LOWER and PROPER functions.
You need a helper cell with a formula like =PROPER(A1)
Gord Dibben MS Excel MVP
On Thu, 9 Jul 2009 05:41:01 -0700, 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
|