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