Formatting Sentence Case in XL 2K3 1

[MeGustaXL]

Hi there,

You know "Sentence case" in Word, where only the first letter of a string is capitalised? Can that be done in Excel 2K3?

I know about UPPER, LOWER and PROPER, but can't see "SENTENCE"

Chris

Someday I'll know what I'm donig...damn!

 

[Scott24x7]

The function you are looking for is called "PROPER"

So =PROPER(C15) will give you "Title Case" in the cell you call the function from.
Cheers

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[SkipVought]

Unfortunately for you, Excel is not a word processor: rather a spreadsheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mintjulep]

=UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)

 

[mintjulep]

Or maybe more bullet proof:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

 

[MeGustaXL]

Scott, thanks, but I already tried PROPER and that's my problem really. PROPER("This is the sentence") comes out as "This Is The Sentence". I already have a load of PROPER sentences, and want to convert them to SENTENCE case, like this:

SENTENCE("This Is An Offending Sentence") needs to result in "This is an offending sentence" You see?

Thanks Skip - really.

Chris

Someday I'll know what I'm donig...damn!

 

[MeGustaXL]

Mintjulep: Nice one have a STAR!

I actually surrendered and pasted the cells into Word, used Change Case>Sentence, then pasted the text back in.

Come on Microsoft - give us a "SENTENCE" function!

Chris

Someday I'll know what I'm donig...damn!

 

[fumei]

Why? Excel is for numbers.

Gerry

 

[Scott24x7]

I would suggest, Excel has many uses. And part of that is textual and string manipulations, usually for making you number look and present better. It's also a VERY strong analytical tool, especially when used with Pivot tables, or as a cube viewer. It is far more than just for numbers...


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[fumei]

I was being facetious. Although: "It's also a VERY strong analytical tool, especially when used with Pivot tables, or as a cube viewer. "

Are those not uses of numbers? Are you suggesting Excel has textual analytical tools? If so, please elaborate as this would be a function I am not aware of.

My (facetious) point was that Excel has (IMO) poor use of text, but for a good reason...it is not a word processor.

Gerry

 

[mintjulep]

I think one could argue that manipulating strings based on some set of rules Excel is actually better than a word processor such as Word.

Without using VBA, Word really has very limited tools manipulating strings.

As an example, take the classic "I've got this text file of names and addresses that I want to parse into a database" question.

The answer is never "put it into Word and manipulate it", it's almost always play with the strings in Excel. Why? Because Excel has native functions that let you attack a string in various ways.

 

[fumei]

let you attack a string in various ways. "

and are these ways not basically numerical????

If the result is a numerical function of those strings, then yes, Excel is better than Word.

However, I challenge you to come up with ANYTHING that is textual manipulation that is superior in Excel.

With the caveat....yes...VBA is required. This is why I made myself understand Word VBA.

Oh and: "As an example, take the classic "I've got this text file of names and addresses that I want to parse into a database" question."

This is NOT word-processing.

Gerry