change capitalize letters to lowercase
i need to have a walk through on setting up my document. I already have 1300
names that I have imported from other programs and files and now need to clean up the misc capital letters and lowercase. PLEASE HELP! On deadline |
change capitalize letters to lowercase
Changing caps to lowercase is done by the LOWER function:
=LOWER(A1) will make it all lower case =PROPER(A1) will make only the first letter capital =UPPER(A1) makes it all uppercase HTH Bob Umlas Excel MVP "Sweetart9699" wrote: i need to have a walk through on setting up my document. I already have 1300 names that I have imported from other programs and files and now need to clean up the misc capital letters and lowercase. PLEASE HELP! On deadline |
change capitalize letters to lowercase
Here's what you're probably looking for. This macro will go down a column of
data and convert all letters to lower case. It stops when if hits an empty cell. Sub Lower_Case() While ActiveCell.Value < "" ActiveCell.Value = LCase(ActiveCell.Value) ActiveCell.Offset(1, 0).Select Wend End Sub "Sweetart9699" wrote: i need to have a walk through on setting up my document. I already have 1300 names that I have imported from other programs and files and now need to clean up the misc capital letters and lowercase. PLEASE HELP! On deadline |
change capitalize letters to lowercase
The free Excel add-in "XL Extras" adds menu items to the Format
menu that offers choices to change the text in the selection to: Upper, Lower, Proper, and Sentence case. The program also does other stuff like sorting sheets and creating a table of contents.. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Sweetart9699" wrote in message i need to have a walk through on setting up my document. I already have 1300 names that I have imported from other programs and files and now need to clean up the misc capital letters and lowercase. PLEASE HELP! On deadline |
All times are GMT +1. The time now is 07:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com