Excel How do i make a range of cells proper text?

[Peter]

I have created an excell spreadsheet from Peachtree accounting. all the
customer names are all caps. i want to select the whole worksheet and use a
formula to make the whole sheet "proper" which will make the first letter of
each work capitlaized and the rest of the work lower case. please be
specific. i am not an excell expert , just a business owner ttrying to get
by. Thanks, peter

 

[Anne Troy]

Hi, Peter. Try this:
http://www.officearticles.com/excel/change_the_case_of_text_in_cells_in_microsoft_excel.htm
There are several ways, and you can choose which one's best depending on how
often you do this.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Leith Ross]

Hello Peter,

Here is a macro to do what you want. I will walk you through the
process of installing and running the macro. It really isn't
difficult.

First, you should print these directions. Next, Copy the macro text
below. It starts at the line 'Start of Code and continues down to 'End
of Code.

To Copy the Macro Code:
1) Move the mouse cursor to the left side of the line 'Start of Code.
2) Press the Left Mouse Button and Hold it.
3) Move the mouse down to the line 'End of Code.
4) The text should be highlighted. If so Release the Left Mouse Button.
If not repeat steps 1 through 3.
5) Press the key marked CTRL and hold it, then press the letter key C.
This will Copy the Macro Code.

Installing the Macro:
1) Open the Excel Workbook the Macro will be installed in.
2) Press the key marked ALT and hold it, then press the key marked F11.
This opens the VBA Editor.
3) Press the key marked ALT and hold it, then press the letter key I.
This will activate the Insert Menu.
4) Press the letter key M. This will insert a macro module into the
Workbook.
5) Press the key marked CTRL and hold it, then press the letter key V.
This will paste the code into the module.
6) Press the key marked CTRL and hold it, then press the letter key S.
This will save your Macro.
7) Press the key marked ALT and hold it, then press the letter key Q.
This closes the VBA Editor and returns you to Excel. The macro is now
installed.

Running the Macro:
1) Select the Worksheet you want to convert into Proper Case.
2) Press the key marked ALT and hold it, the press the key marked F8.
This will display your list of Macros.
3) Select the macro called "ConvertToProperCase" by Left Clicking it.
4) Left Click "RUN"

That's all there is to it. The macro will make all the cells that have
data in them Proper Case.

Sincerely,
Leith Ross