I want to be able to change capital letters into title case. A colleague and
I have
tried to follow the instructions given by the online Help but cannot figure
out how to make this work. The instructions are not very well explained

Try the =proper() function...

If the text that you want to represent a change to the format of the letter
characters is found in cell A2 the correct syntax would be

Proper case =proper(A2),
Upper case =upper(A2),
Lower case =lower(A2)
--
Thanks for your help -
Joe Mac


"philippos" wrote:

I want to be able to change capital letters into title case. A colleague and
I have
tried to follow the instructions given by the online Help but cannot figure
out how to make this work. The instructions are not very well explained

Use the function PROPER.

If your text string is in A1, then =PROPER(A1) will yield proper case.
--
Brevity is the soul of wit.


"philippos" wrote:

I want to be able to change capital letters into title case. A colleague and
I have
tried to follow the instructions given by the online Help but cannot figure
out how to make this work. The instructions are not very well explained

What part of the Help is giving you trouble?

If the TEXT STRING is in A1, in A2 enter =PROPER(A1) to produce Text String in
A2

You can copy this formula to other rows and columns.

When happy with results, select all the cells with formulas and Copy them.

EditPaste SpecialValuesOKEsc.

Now delete the original data.


Gord Dibben MS Excel MVP

On Wed, 6 Sep 2006 04:13:01 -0700, philippos
wrote:

I want to be able to change capital letters into title case. A colleague and
I have
tried to follow the instructions given by the online Help but cannot figure
out how to make this work. The instructions are not very well explained