Help w/ the PROPER function

I have a worksheet w/ all caps & I need to change it so that the first letter of each word is capitalized. I used Excel Help and it said to use the PROPER function, except I can't seem to make that work. Any help? Thanks.

Hi,

Say you have "PROPER" in cell A1. Put this formula into B2

=PROPER(A1)

The copy Paste special values in column B and you can deleted Column A

VBA Noob

The PROPER function is used like so..........

Assume Column A is ALL CAPS

In B1 enter =PROPER(A1) to return All Caps

Copy B1 down column B or double-click on the fill handle.

Copy column B and paste special>value>OK>Esc

Delete column A

If you have a great many of these to do you could use VBA macro which would
change them all at once, in place without the formulas to get rid of later.

If you wish the macro, post back.


Gord Dibben MS Excel MVP


On Fri, 4 Aug 2006 13:38:19 -0400, arneson
<[email protected]> wrote:

>
>I have a worksheet w/ all caps & I need to change it so that the first
>letter of each word is capitalized. I used Excel Help and it said to
>use the PROPER function, except I can't seem to make that work. Any
>help? Thanks.