i have a list in excel, i want to capitalize all the list (the first letter
of each word) (2000 rows of songs) do i highlight the whole thing and do
=proper ??????
do i have to do it line by line. what i mean by does not work is , if i put
my cursor in one cell and i click fx ,then go to proper on the line that i am
pointing at i see the = sign and the ( ) where i should put the line i want
to edit , which gives me a 0 in that space, do you know what i mean. if
however i choose the following line for example it does tha capitalizong for
that line and not the line i ariginally put the cursor on, i'm sure i am
doing something wrong. excuse my ignorance on this matter but i am fairly new
and don't understad all this programming language, i would a prreciate a step
by step account of WHAT TO DO, i am helpless, thank you for your patience
rosy

"Ron Coderre" wrote:

I think you'll need to define "does not work".

If....
A1: jingle bells
A2: =PROPER(A1)
then A2 displays Jingle Bells

If you want to replace the original with the Proper Case then...
Select A2
EditCopy
Select A1
EditPaste SpecialValues

A1 wil now be Jingle Bells

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"rosygucci" wrote:

Hi, I am trying to find a way of capitalizing the first letter of every word
in an excel listing of music. i tried the function that was suggested to me
in the help =proper(cell#) and it does not work. please someone help me. i am
going crazy!!! i need to know where to point when i am applying the function.
i ahve a list of 2000 lines in excel to fdo and would like to do it the
quickest possible.
thank you
rosy