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

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

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

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