capitalization

[Trina]

Is there a way to make a text column that is already input
capitalize the first character?

 

[Greg]

Is there a way to make a text column that is already input
capitalize the first character?

Assuming your data is in column A, insert a blank column next to it,
then enter the following formula in B1:

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

Copy the formula down column B as far as your data goes.

Once everything looks good, you can use Paste Special -> Values to
copy the formula results in place of your original data.

 

[David McRitchie]

Hi Trina,
I would suggest a macro to change Text constants.
If you mean the first character of each cell see the Proper_case
macro and it's supporting macro Proper_case_inner on my
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

If you mean the first letter in the cell and next word after a period
Tushar Mehta has a macro see related area (links) at the above.

 

[stefano gatto]

try =PROPER(A1)