Capitalization

[L Day]

Can someone tell me how to capitalize the first letter in
each row of a specified column in an excel worksheet?

 

[Dave R.]

With a formula u can use-

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