Capitalizing first word only...

[Guest]

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

 

[Niek Otten]

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

 

[Bob Umlas]

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

 

[Guest]

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

 

[David McRitchie]

If you want it to work for multiple sentences in a cell, see Tushar's posting.
http://groups.google.com/group/microsoft.public.excel.programming/msg/7f48f4652a67da48