In a helper column you could have this formula:

=PROPER(B2)

assuming your street name starts in cell B2.

Copy this down as far as required, and then fix the values (select all
the cells with the formula in, click <copy, then right-click and
select Paste Special | Values (check) | OK then <Esc). Now you can
copy/paste the values from the helper column to overwrite the
originals in column B, and then delete the helper column.

Hope this helps.

Pete

On Nov 5, 3:49*pm, 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.