Help w/ the PROPER function

[arneson]

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

 

[VBA Noob]

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

 

[Gord Dibben]

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