Let's experiment on a new workbook
Type some stuff in to A1:A5; like Bill Gates, LAUREN, Super Man, etc
In cell B1 enter =PROPER(A1) and copy it down to cell B5
Did that work?
Get back to us for more.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"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!
-Lauren