Is there a way to capitalize just the first word of a cell (like a sentence
would be capitalized)?

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

--
Kind regards,

Niek Otten

"jojojpinkerton" wrote in message
...
Is there a way to capitalize just the first word of a cell (like a
sentence
would be capitalized)?

=upper(left(a1,1))&lower(mid(a1,2,255))
Bob Umlas
Excel MVP


"jojojpinkerton" wrote in message
...
Is there a way to capitalize just the first word of a cell (like a
sentence
would be capitalized)?

=proper(a2) if your data was in a2.

"jojojpinkerton" wrote:

Is there a way to capitalize just the first word of a cell (like a sentence
would be capitalized)?

If you want it to work for multiple sentences in a cell, see Tushar's posting.
http://groups.google.com/group/micro...48f4652a67da48
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jojojpinkerton" wrote in message
...
Is there a way to capitalize just the first word of a cell (like a sentence
would be capitalized)?