Copying the PROPER function

[Lori]

I have a file where I need to change the case in a couple
columns to Title Case which is done with the PROPER
function. The problem I am running into is how to copy
this column and apply it to the entire column. I am
using Excel 97.

For example, cell c1 contains the name MIKE SMITH. I
placed this formula in the cell: =PROPER("MIKE SMITH")
to change it to Mike Smith. When I try to do a Paste
Special to copy the formula only, Mike Smith is placed in
each cell instead of each respective name. How can I
copy this function to other cells?

Thanks...Lori

 

[Fred Smith]

I would do it by:

1. Insert a column after C.
2. In D1, put =Proper(C1) and copy down.
3. Convert Column D to values (using Paste Special)
4. Delete column C.