You did post the same message on Nov 5th and received replies at that time.


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 09:08:13 -0800, sos-DC
wrote:

Thank you, I'll try that.

(do you know how handles the date/time for postings? Today is Nov 19 but it
says I posted this on Nov. 5)

"Mike H" wrote:

try

= proper(a1)

If you need a macro to automate this provide more detail.

Mike

"sos-DC" wrote:

I have a database of over 1,700 line in which more than half have addresses
in ALL upper case.

I need an easy way to change MAIN STREET to Main Street without having to
retype most of the database.

Can this be done?

Thanks.