Thats what I did. What I meant was, can't I select ALL the cells I need it
to apply too, such as A2 through H925 and apply it to ALL the cells. Not
just one column at a time. Which this way I am doing A2 through A925, I type
in the formula in I2 (which is my first available BLANK cell) then I used the
fill handle to take that down to I925. Clicked Copy, then did paste special
over cells A2 through A925. Then I deleted column I's information then did
cells B2 through B925 by typing in column I "=PROPER(B2)" then fill handling
that down to I925 again and so on and so forth. So I am doing each column
individually. Is there an easier way besides doing each individual column??

"Black Knight" wrote:

"Lauren" wrote in message
...
Can someone please help me? I imported data from another program to
Excel,
it is an address database. Some of the entries are all capital, some are
all
lowercase, some are proper. I would like to switch everything to proper.
I
have tried numberous times to do EXACTLY what I am reading about copy and
pasting, entering the formula, designating the cells I want it to apply
to.
However, when I do it, nothing changes.

I am absolutely confused and frustrated. Can someone please help me
resolve
this issue. Thank you!


Here's one way ..........

If your data is say in cells A1 to A100 then in cell B1 put =PROPER(A1)
and copy this down through all the cells to B100

Hey presto, all the cells in column B will display the 'proper' version of
column A

Then if you like you can copy all the cells in column B

'Paste Special' into column A (selecting the values option from the dialogue
box)

Then delete column B

Hope this helps