View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Hudson
 
Posts: n/a
Default How do I change text from all caps to normal type?

Hi Karol,

=PROPER(A1)
--
Ken Hudson


"Karol" wrote:

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