Thread: Changing case
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liliana[_4_] Liliana[_4_] is offline
external usenet poster
  
Posts: 39
Default Changing case
?B?RGluZ2JhdGljdXMtTWF4aW11cw==?= <Dingbaticus-
wrote in news:08ED6C2A-F74F-49B1-99A6-
:

Is there a function that will take all caps and change it into sentance
format, or take all lower case and change it into sentance format ?


The proper() function should do the trick.

=Proper(A1)


--
Lil
Reply With QuoteReply With Quote