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.


--
arneson
------------------------------------------------------------------------
arneson's Profile: http://www.excelforum.com/member.php...o&userid=37111
View this thread: http://www.excelforum.com/showthread...hreadid=568438

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568438

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 specialvalueOKEsc

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
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.