How do you capitalize text in an Excel worksheet ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you change current small text in a cell to CAPITALS? 3
how to turn automatically in CAPITALS parts of text in excel ? 3
How do I create a macro the capitalizes an entire excel sheet? 3
userform Field forcing Capital Letters - Thank you 3
Comparison of two lists of text and finding commonalities 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I change All Capitals Text to normal Text 1
In a column, how can I capitalize ALL text? 6

Back
Top