Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing capslock letters into normal letters
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing capslock letters into normal letters
Great, thanks!
"Gary''s Student" wrote: =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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove dashes between letters and between letters and digits | Excel Worksheet Functions | |||
normal into Capital letters automatically | Excel Worksheet Functions | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
change lower letters to upper letters | Excel Discussion (Misc queries) |