Use of PROPER command

conway chester · May 12th, 2002, 08:48 PM

Can?t get column of all cap names converted to upper/lower. Did this: Clicked on [ = ] preceding formula bar. Selected PROPER as function syntax in NAME box to left of the [ X check = ] formula area. A window opened saying: [ FORMULA RESULT = OK CANCEL ]. Click OK & this window closed & in the 1A field the word FIRM is changed to [ #NAME? ]

From here (and maybe even before here) I?m lost as to how to proceed.

Following is typical source column A data.
NAME is the column heading in position A1
FLIPCHART is the 1st firm name beginning in column A2.

NAME
FLIPCHART
GERE'S ALTERNATIVE CHOICES
HELPING HANDS
HIGH TECH MEDICAL USA
HOLISTIC MEDICAL SUPPLY CO
Etc......

What is needed to cause each word in column to convert with capital 1st letter & remainder of letters in lower case?

Running EXCEL 2000 on Win98se Compaq tower.
Will greatly appreciate help on this.
Thanks. conway-c@pacbell.net 5-12-02 Sun.

Nimrod · May 12th, 2002, 08:53 PM

If the Word or Pharse is in A1 then copy the following into B1
=PROPER(A1)
if you have values in A2 copy formula from b1 to b2 etc

Nimrod · May 12th, 2002, 09:01 PM

To do this with the ToolBar formula proceed by:
1- select the cell in which you want the result i.e. B2
2- select the "=" from the toolbar
3- select the "proper" forumal
3- drag the formula popup window out of your way
4- While the cursor is flashing in the "text" box of the popup window
5- Select the source cell i.e. A2
6- press the OK button in the formula popup windo

May 12th, 2002, 08:53 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	If the Word or Pharse is in A1 then copy the following into B1 =PROPER(A1) if you have values in A2 copy formula from b1 to b2 etc __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

May 12th, 2002, 09:01 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	To do this with the ToolBar formula proceed by: 1- select the cell in which you want the result i.e. B2 2- select the "=" from the toolbar 3- select the "proper" forumal 3- drag the formula popup window out of your way 4- While the cursor is flashing in the "text" box of the popup window 5- Select the source cell i.e. A2 6- press the OK button in the formula popup windo __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 12th, 2002, 08:48 PM	#1
conway chester New Member Join Date: May 2002 Location: Irvine, CA Posts: 1	Can?t get column of all cap names converted to upper/lower. Did this: Clicked on [ = ] preceding formula bar. Selected PROPER as function syntax in NAME box to left of the [ X check = ] formula area. A window opened saying: [ FORMULA RESULT = OK CANCEL ]. Click OK & this window closed & in the 1A field the word FIRM is changed to [ #NAME? ] From here (and maybe even before here) I?m lost as to how to proceed. Following is typical source column A data. NAME is the column heading in position A1 FLIPCHART is the 1st firm name beginning in column A2. NAME FLIPCHART GERE'S ALTERNATIVE CHOICES HELPING HANDS HIGH TECH MEDICAL USA HOLISTIC MEDICAL SUPPLY CO Etc...... What is needed to cause each word in column to convert with capital 1st letter & remainder of letters in lower case? Running EXCEL 2000 on Win98se Compaq tower. Will greatly appreciate help on this. Thanks. conway-c@pacbell.net 5-12-02 Sun.