Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Proper Function with Plural Words (2002)

    Hello,

    How can I use the Proper function with plural words..

    example:
    ISLAND'S turns into Island'S

    Is there anyway to make it "Island's"

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Proper Function with Plural Words (2002)

    How about:
    <pre>=SUBSTITUTE(PROPER(A1),"'S","'s")</pre>


    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>your example is not a "plural word" it is possesive word. There should be no problem with plural words. The apostrophe (') is what confuses the proper function...

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Proper Function with Plural Words (2002)

    Thanks! I didn't think of that <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    (I've never been very good at the subject of grammer - so an apostrophe makes a word possesive?)

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Proper Function with Plural Words (2002)

    Yes, in general (in English/american at least) an apostrophe with an "s" is possesive

    The island is beautiful (singular)
    The islands are beautiful. (plural)
    The island's beauty was enhanced by the blue ocean.(singular possesive)
    The islands' beauty were enhanced by the blue ocean.(plural possesive)

    Though an apostrophe can also designate a contraction" I'm (I am), don't (do not) it's (it is), etc.

    Possesive pronouns do not have the apostrophe (some do not have the "s"): mine, yours, his, hers, its, ours, yours, theirs

    Steve

Posting Permissions

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