Thread: changing case
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sos-DC[_2_] sos-DC[_2_] is offline
external usenet poster
 
Posts: 20
Default changing case

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.