Converting UPPER CASE to LOWER CASE

=PROPER(A1) and copy down as far as needed. note though that this will make every word start with a capital, which for "and" "the" and "a", etc may not be appropriate

Re: =PROPER(A1) and copy down as far as needed. note though that this will make every word start with a capital, which for "and" "the" and "a", etc may not be appropriate

Anno:

I guess I am brain dead tonight, can you be more specific as to how etc?

Re: =PROPER(A1) and copy down as far as needed. note though that this will make every word start with a capital, which for

ron
no problem - know the feeling.
say your column of names is in column a, from a1 to a5000. in cell b1, enter =PROPER(A1)and press enter/ok. then, with cell b1 still selected, put the cursor at the bottom right of the cell so the cursor turns into a black cross. click and drag down as far as you need to (ie. to cell b5000) and release the mouse button. this should leave a series of entries from b1 to b5000 which have an initial capital for each word.
what i meant by it not being suitable was that for a company name like 'ACME TOOL AND DIE' it will return 'Acme Tool And Die', and if you don't want the 'and' to have the initial capital we've run into trouble. If you don't mind that though it's fine.
the other thing i didn't mention in my initial reply was that although b1-b5000 will show on the sheet as names, if you try to copy and paste to somewhere else it will copy and paste the formulas, not what you see. to fix this, select b1-b5000 (quick way is ctrl+shift+down arrow), copy and paste special values (edit menu>paste special and select the 'values' option then press enter/ok). this will leave you with the actual names rather than the formulas. if this doesn't make sense, just try it - you'll see what i mean after you do it.
hope this helps - let me know if you need any more help, especially if the And/and thing is a problem.
anno

Thanks ANNO as that will save me hours of time.... Worked Perfect!!!!