Casing
 

Hi

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

Thanks

Casing
 

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

Casing
 

Row or cell?

If a cell, say A1, contains a single word like qwerty then in B1 enter
=PROPER(A1) to return Qwerty

Copy down column B

If the cell contains two words do you want just the first one Proper or both
of them

qwerty asdfg as Qwerty asdfg or Qwerty Asdfg


Gord Dibben MS Excel MVP


On Wed, 8 Oct 2008 15:53:01 -0700, PL wrote:

Hi

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

Thanks