M
Margot
Can anyone tell me how to change UPPERCASE TEXT to Title
Case for a whole column in Excel (97)?
Case for a whole column in Excel (97)?
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.
B
bxb7668
I don't know of a way within Excel. As a workaround, I'd copy the
entire column to Word and use Shift+F3 to change the case. Then copy
it back to Excel. This assumes that there are no equations in that
column. Hopefully someone will answer with a better way. Good luck.
Brian
entire column to Word and use Shift+F3 to change the case. Then copy
it back to Excel. This assumes that there are no equations in that
column. Hopefully someone will answer with a better way. Good luck.
Brian
A
Andy B
Hi
For a non-VBA solution, use a helper column alongside your existing column
with
=PROPER(A1)
in and then fill down. If you are happy with the result, you can then select
the whole range and Copy / Paste Special / Values to fix the values in
place, and then delete your original (if required)
For a non-VBA solution, use a helper column alongside your existing column
with
=PROPER(A1)
in and then fill down. If you are happy with the result, you can then select
the whole range and Copy / Paste Special / Values to fix the values in
place, and then delete your original (if required)
D
Dave R.
You can use a formula like
=PROPER(A:A) and copy it down..
=PROPER(A:A) and copy it down..
L
Lady Layla
How about inserting a column next to the colum in question, in the top cell of
the inserted column type =proper(point to cell next to it)
Copy this entry down the entire cell you need
Then copy the column you just created, highlight 1st entry in col you wanted
changed and Paste special, values
Delete inserted column
: I don't know of a way within Excel. As a workaround, I'd copy the
: entire column to Word and use Shift+F3 to change the case. Then copy
: it back to Excel. This assumes that there are no equations in that
: column. Hopefully someone will answer with a better way. Good luck.
: Brian
:
: : > Can anyone tell me how to change UPPERCASE TEXT to Title
: > Case for a whole column in Excel (97)?
:
:
the inserted column type =proper(point to cell next to it)
Copy this entry down the entire cell you need
Then copy the column you just created, highlight 1st entry in col you wanted
changed and Paste special, values
Delete inserted column
: I don't know of a way within Excel. As a workaround, I'd copy the
: entire column to Word and use Shift+F3 to change the case. Then copy
: it back to Excel. This assumes that there are no equations in that
: column. Hopefully someone will answer with a better way. Good luck.
: Brian
:
: : > Can anyone tell me how to change UPPERCASE TEXT to Title
: > Case for a whole column in Excel (97)?
:
: