One work-around is to use a helper column with the formula
=PROPER(A1) where the offending text is in A1.
Once the conversion is done, you can Copy/Paste Special the helper
column to values and delete the original column.
hth
ScottO

"gojackets1979" wrote in
message ...
| Why is the formatting of fonts in Excel limited compared to Word?
I have a
| document that has "descriptions" and we want to initial cap the
verbiage.
| The only way that I know to do it is to go in and either delete and
re-type
| the letter or use the Insert feature. It would be nice to be able
to click
| an entire column, click Format, Font, Change Case, Initial Cap like
you can
| in Word. Talk about saving keystrokes!!!! Thank you.
|
| ----------------
| This post is a suggestion for Microsoft, and Microsoft responds to
the
| suggestions with the most votes. To vote for this suggestion, click
the "I
| Agree" button in the message pane. If you do not see the button,
follow this
| link to open the suggestion in the Microsoft Web-based Newsreader
and then
| click "I Agree" in the message pane.
|
|
http://www.microsoft.com/office/comm....mspx?mid=73d8
26aa-2f00-4f67-a3e0-c91c384b9ff7&dg=microsoft.public.excel.misc