The formula should be typed in an adjacent column and copied down. Then,
Copy PasteSpecial Values on that column to get rid of the formulas, and
then delete the original column if desired.

Vaya con Dios,
Chuck, CABGx3



"Ronnie" wrote:

I do want PROPER (title Case). I am changing from Upper Case. When i type
the formula in the cell, it deletes my text and leaves: =PROPER(A2)
--
Ronnie


"Mike" wrote:

Proper capitalises the first letter and any subsequent letter that doesn't
follow a letter. What you want is Upper.

for example =upper(A1) capitalises the whole text string in A1
Mike

"Ronnie" wrote:

I'm trying to change the case of text in a column. The Excel Help tells me
to add a formula of =PROPER. I've tried this, but it is not working. The
help guide is not making this clear to me. I have tried to add this formula
to the top cell in the column and drag it down through the cells. I've tried
a few other things, but to no avail. Can anyone offer me any clues?
--
Ronnie