Changing case

[Dingbaticus-Maximus]

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 ?

 

[Liliana]

=?Utf-8?B?RGluZ2JhdGljdXMtTWF4aW11cw==?= <Dingbaticus-
(e-mail address removed)> wrote in (e-mail address removed):

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)

 

[Rick Rothstein]

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 Rothstein]

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.

 

[Liliana]

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).

Now, why did I recall it that way! Thank you, I stand corrected.

That leaves a lot of work to do to split a paragraph and apply sentence
case to each sentence.

http://vbamacros.blogspot.com/2007/09/sentence-case.html

http://www.codeforexcelandoutlook.com/excel-vba/case-changing-in-excel/

Then you need to consider proper names, the personal pronoun, etc.

Seems better to set options AutoCorrect to Capitalize for you and ensure
replace text as you type is checked.


Lil
--