How do you capitalize text in an Excel worksheet ?

M

Maria R

I am having trouble capitalizing selected text in a worksheet, without
getting a 0 as a result or requiiring the corrected text to appear in a
nother cell than the original. Has anyone else encountered this problem?
 
G

Gord Dibben

Maria

You cannot change case in place without using VBA.

The UPPER, LOWER and PROPER Functions require a helper cell.

See Frank's post with link to a VBA method.

Gord Dibben Excel MVP

On Fri, 8 Oct 2004 07:55:03 -0700, "Maria R" <Maria
 
Top