Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Use of PROPER command

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Irvine, CA
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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>

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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>

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •