How do I change text from all caps to normal type?

[Karol]

I have text (addresses) that need to be changed from all caps to caps and
lowercase. How do I do this?

 

[Bearacade]

=Proper()

HTH

 

[Bearacade]

=Proper()

HTH

 

[Ken Hudson]

Hi Karol,

=PROPER(A1)