This sounds like a one time job.
Do not use a macro.
Assuming Names and Addresses are in columns A & B
Insert two columns at C
In the new C =Proper(A1)
In the new D =Proper(B1)
Select C1:D1, Copy Down.
Select C:D, Copy, Paste Special Values.
Inspect and edit.
Delete Columns A:B

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org

"CLew " wrote in message
...
Dear all,

I have a Excel sheet with 13,000 names and address that are all in
upper case. Is there way to automate the Proper function so that the
cases are corrected? That is, the first character of the first and
last names is in upper case and rest in lower case. I'm rather new to
using macros in Excel.

Thanks in advance!
-Chris


---
Message posted from http://www.ExcelForum.com/