Try this macro

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Molly" wrote in message
...
I would like to be able to change some text in an address field from upper
case to proper case. How can I do this for multiple records at one time?