How do I change the case of text in more than one entry at a time

[Molly]

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?

[Peo Sjoblom]

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" <[email protected]> wrote in message
news:[email protected]...
>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?

[SimonCC]

If you don't want to deal with macros, you can try
=PROPER(address)
Although it doesn't work too well with state abbreviations.

-Simon

"Molly" wrote:

> 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?