Thanks Harlan

You helped me heaps, that makes more sense and the case actually changed.
woohoo
THANK YOU

"Harlan Grove" wrote:

"sonia" wrote...
THat doesn't help, I know it says to do that, but where do I put it,
and how do I get it to work, I've put it in the formula bar, i've put
it in different cells, but it's not changing the case for me, that's
what i need help with.
....

I'm going to guess you're new to spreadsheets generally.

You have text in some cell, and you want to change it to proper case. For
example, cell B2 containing "ACME SUPPLIERS" (without the double quotes,
which appear here only to show where the text begins and ends), and you want
it to appear as "Acme Suppliers". There's no simple way to do this in cell
B2 itself. The direct, manual approach would be to move to cell B2, press
the [F2] key, type

")

(this time including the double quote), press the [Home] key, type

=PROPER("

(again including the double quote), then press the [Enter] key. This would
make B2 contain the formula

=PROPER("ACME SUPPLIERS")

which would display as "Acme Suppliers".

What others have suggested involves using other cells. For example, enter
the formula =PROPER(B2) in cell C2. C2 would now show the value of cell B2
in proper case. If you want that in cell B2, you could copy cell C2, move to
cell B2 and run the menu command Edit Paste Special, then choose Values in
the Paste Special dialog. That would copy the value of cell C2 into cell B2.
Then you could clear cell C2.