How to change case in excel? MS Help is no help

P

philippos

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
 
J

Joe Mac

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)
 
D

Dave F

Use the function PROPER.

If your text string is in A1, then =PROPER(A1) will yield proper case.
 
G

Gord Dibben

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.

Edit>Paste Special>Values>OK>Esc.

Now delete the original data.


Gord Dibben MS Excel MVP
 
Top