I just learned about this the other day. (I told you I was an Excel novice.)
That will save me a lot of time at work!

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Enter the formula in a helper column.

Assuming column A is your data in lower case.

In B1 enter =UPPER(A1)

Double-click on the fill handle of B1 to copy down.

When happy, select column B and EditPaste Special(in
place)ValuesOKEsc.

Delete original column A


Gord Dibben MS Excel MVP

On Wed, 14 Feb 2007 11:56:20 -0800, Dean-Xceldata
wrote:

I read the help, but it doesn't tell me where to enter the formula.