Use of PROPER command

conway chester

New Member
Joined
May 10, 2002
Messages
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.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,943
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top