Changing case
 

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 ?

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

Changing case
 

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

Changing case
 

If we are talking a single sentence (with no proper nouns or name in the middle anywhere), you can do this...

=UPPER(LEFT(A1))&LOWER(MID(A1,2,LEN(A1)))

If you are talking about multiple sentences in a single cell, well, then a formula starts to get complicated since sentences can end in periods, question marks and exclamation marks.

--
Rick (MVP - Excel)


"Dingbaticus-Maximus" wrote in message ...
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 ?