If you want to change, say, cell A2, go to another column, say B2, enter:

=UPPER(left(A2,1))&lower(right(len(A2)-1)

this will give upper case first character, lower case rest of cell

"PL" wrote:

Hi

How do I make the 1st letter of each row Big Case, without doing it for each
cell?

Thanks