# Excel question

1. Excel question
Is there an easy formula to capitalize all the words? I mean to make the first letter only a capital letter. Example change flowers to Flowers.

I want to do this to every word on the spread sheet.

There is no consistency in the way the merchants do it so I need to if my site is to look right.

Thanks

2. Function is called "Proper" [functions in parens - proper case (proper), lower case (lower) and upper case(upper)].

=Proper(A1)

3. Thank you but it wants me to insert the text in quotes. Is there any way I can make the whole sheet turn to Proper??

Can you tell me what to do in a bit more detail?

The instructions in Excel are about as clear as mud. They talk all around and about functions but don't tell you how to do it.

4. The way I do it is to insert a new column to the left of the column I want to capitalize, insert the formula in the first cell and drag down to where the column to the right ends. Then, I copy the whole column I just created. Now I highlight the column I want to apply the formula to, and hit Paste - but I right click on Paste and hit "Paste Special", then I click the formulas button. Now I erase the column I used to get the formula's results.

If the above made any sense to you at all, (as I am no Excel expert), you can apply that process to every column.

Hope it works out.

5. I copied the colum to the left and put "the formula"
=Proper(A1) into A1 and all it did was give me an error.

Is that what you meant for me to do?

~~~~~~~~~~~~~~~~~~~~

Yea~!

Got it!

I had to copy the formula into B1!!!!!

Thank you so much!!!!!

6. Ok just saw the bottom part of your post, yeah! Glad it worked.

7. I gave you the formula for translating the text in one cell (a1) into the proper case in another cell (your choice of cells).

If you want to convert a range, you can use Visual Basic code to do it:
http://www.ozgrid.com/VBA/force-case-text.htm

If VB or Macros are foreign animals to you, you might find a free macro someone else has built and download it - here's one for your situation that I found (but did noit test in any way):
http://www15.brinkster.com/corvette/...hangeCase1.asp

8. Tell you what. I am glad it worked, too!!!!

You guys are the greatest!

9. I found that you can do a whole sheet at once by copying all the columns and dragging diagonally across the second set of columns!!

10. I have a macro, which will allow you to select any text, and upper, proper, or lower-case it in excel.

Let me know if you are interested, I'll post it. It's also at my site (free, of course).

Fred