To change the entire used range on a worksheet at once would require a Macro.

Here is one to change all cells to Proper Case.

Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo.


Gord

On Tue, 8 Jan 2008 05:41:01 -0800, CT Man
wrote:

OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks.

CT Man

"Gord Dibben" wrote:

Don't click on the fx button, just type Per's formula into a cell.

Also, open Help and type in "proper". When reading about that function there
will be a "how" button showing you how to copy the example formula to the
worksheet.

Also, since things like formulas are confusing, perhaps a basic tutorial in
Excel would assist.

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 14:44:01 -0800, CT Man
wrote:

I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this

"Per Erik Midtrød" wrote:

On Jan 7, 11:26 pm, CT Man wrote:
Help is too confusing. I can tell from it that I have to do a formula for
proper case, but it is unclear how to do it

If you have your text i cell A1, but this formula in some other cell:
=Proper(a1)

Per Erik