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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com