No, I wrote =PROPER(A1)
and drag the fill handle down the column
This is a fundamental skill in Excel - typing a single formula and them
making it apply to various rows in a column
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Lauren" wrote in message
...
OK, what I am doing right now:
My worksheet has 925 rows and colums B-I.
In Colum J, I typed =PROPER(B2:B925) However, If I try to copy and paste
special, it doesnt apply to all of them. Do I really have to do it each
individual column and use the fill handle and stuff? There isnt an easier
way without using a macro? Something where I could type in
=PROPER(B2:I925)
and it apply to all rows and colums?
If not, then this is still better than retyping everything.
Thanks for any help.
"Bernard Liengme" wrote:
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