Format fonts (ie, initial cap) in Excel like you can in Word.

[Guest]

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/com...0-c91c384b9ff7&dg=microsoft.public.excel.misc

 

[ScottO]

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

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/community/en-us/default.mspx?mid=73d8
26aa-2f00-4f67-a3e0-c91c384b9ff7&dg=microsoft.public.excel.misc