capitalization

  • Thread starter Thread starter Trina
  • Start date Start date
T

Trina

Is there a way to make a text column that is already input
capitalize the first character?
 
Trina said:
Is there a way to make a text column that is already input
capitalize the first character?
Click to expand...

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.
 
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.
 
Back
Top