"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