Change a Word to Sentence Case

[John D O'Connor]

Is there a function that will convert words to sentence case?

an example in A1 I have NEW YORK. I want to include A1 in a CONCATENATE
function but I want displayed "New York" - can it be done?

Thanks

 

[Bob Phillips]

John,

=PROPER(A1)

CONCATENATE is superfluous as well, just use =A1&B1&...
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[A.W.J. Ales]

=PROPER(F1), where F1 contains NEW YORK

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[John D O'Connor]

Thanks guys, this Excel is amazing, if you think it can be done - it can,
just pity that the Help on the application wasn't as "heplful"

 

[Dave R.]

I don't know where you're looking, but try going to: Insert>Function .. then
look for functions that deal with Text, and you'll find it in there along
with a bevy of other helpful things.

 

[Gord Dibben]

John

Technically that is "Proper" case, not "Sentence" case.

Sentence case Uppers the first word only of a string of words.

Gord Dibben Excel MVP

 

[Bob Phillips]

But the OP asked to convert NEW YORK to New York, so although they said
sentence case, they meant Proper case, so Auk was correct in his response.

Bob

 

[Gord Dibben]

Bob

Nowhere in my post does it imply that Auk was incorrect with his response.

Simply pointing out to the OP(see "John" salutation) the difference in cases.

Gord