Hi
see:
http://www.mvps.org/dmcritchie/excel/proper.htm

--
Regards
Frank Kabel
Frankfurt, Germany


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/