=PROPER(A1)
=PROPER(A2)

Then copy those cells, paste values over A1 and A2, and delete the cells with the formulas.

--
HTH,
Bernie
MS Excel MVP


"Olayah" wrote in message
...
I've created my own data source in Excel. The first 2 cells are mostly all
caps. I want to have them proper. I've formatted all the cells to general.
I've tried all sorts of ways to enter a formula but nothing seems to work. I
keep getting a "name?" error. Is there an easy way to change the text w/o
retyping it. I'm beginning to think that might be easier. Thanks!