sorry just a correction for Capitalization question

[elisa]

A correction for the capitalization problem I had earlier. I want "field Trip Ex" in that format. So first word not capitalized all the other one are.
Thank you again.

 

[Mark W.]

If A1 contains "field trip ex"...

=CHAR(CODE(LEFT(PROPER(A1)))+32)&RIGHT(PROPER(A1),LEN(A1)-1)

...will produce "field Trip Ex".

 

[mdfh]

Or :-

=REPLACE(PROPER(A1),1,1,CHAR(CODE(LEFT(PROPER(A1),1))+32))
This message was edited by mdfh on 2002-04-30 08:27