P PL Oct 8, 2008 #1 Hi How do I make the 1st letter of each row Big Case, without doing it for each cell? Thanks
S Sean Timmons Oct 8, 2008 #2 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
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
G Gord Dibben Oct 9, 2008 #3 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
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
