T
Trina
Is there a way to make a text column that is already input
capitalize the first character?
capitalize the first character?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Greg
Trina said: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.
D
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.
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.
S
stefano gatto
try =PROPER(A1)