Re: Format text not all caps

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 02/02/04 

Date: Mon, 2 Feb 2004 21:11:39 -0000

The others have you given the answers you need, but just to show you that the
Help does indeed tell you how to apply it:-

PROPER - Straight out of *Help on this function* when you look at the function
in the function list.

Capitalizes the first letter in a text string and any other letters in text that
follow any character other than a letter. Converts all other letters to
lowercase letters.

Syntax
=PROPER(text)
Text is text enclosed in quotation marks, a formula that returns text, or a
reference to a cell containing the text you want to partially capitalize.
Example
The example may be easier to understand if you copy it to a blank work***.
 How?
Create a blank workbook or work***.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the work***, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the
results, press CTRL+` (grave accent), or on the Tools menu, point to Formula
Auditing, and then click Formula Auditing Mode.

      A
1 Data
2 this is a TITLE
3 2-cent's worth
4 76BudGet

FormulaDescription (Result)

=PROPER(A2)Proper case of first string (This Is A Title)
=PROPER(A3)Proper case of second string (2-Cent'S Worth)
=PROPER(A4)Proper case of third string (76Budget) 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Justin" <jdignam@sbcglobal.net> wrote in message
news:unGqBcb6DHA.2480@TK2MSFTNGP12.phx.gbl...
> I am doing a mail merge from an xls file into word.  The excel file that I
> purchased is in all caps, ie JOHN SMITH.  I would like to change the xls
> file to be John Smith.  I see from excel Help something called Proper, but
> it doesn't tell me how to apply it to columns or cells.  How do I do this???
> I have no problme actually performing the mail merge.  The text needs to be
> changed within excel so as not to change what I have in the word source doc
> .
>
> Thanks from Southern California.
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004