I don't think the PROPER function's output would be considered "sentence format"... I image that format to be first letter of sentence upper case and the rest lower case (unless there is a proper name in the middle somewhere).

--
Rick (MVP - Excel)


"Liliana" wrote in message .16...
?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