Can someone tell me how to change capital letters to small letters in excel? is there any option, if no, can get a vb script for that? I need to change for a series of data, so the command UPPER, LOWER or PROPER can not use.
thanks
toms
Can someone tell me how to change capital letters to small letters in excel? is there any option, if no, can get a vb script for that? I need to change for a series of data, so the command UPPER, LOWER or PROPER can not use.
thanks
toms
Last edited by SMILE; 04-22-2007 at 06:19 AM.
This link may help
http://www.cpearson.com/Excel/case.htm
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thank you
It helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks