+ Reply to Thread
Results 1 to 10 of 10

function in to make text plural?

  1. #1
    Mis
    Guest

    function in to make text plural?

    Hi,
    I'm looking to copy 1000 cells of singular form text into the next column
    and make it plural. Is there a function to do that?

    Thanks in advance!

  2. #2
    Groovy_Kincaid
    Guest

    RE: function in to make text plural?

    Hi Mis,

    Try this:

    In the column to the right of your singular word, enter the letter s. This
    is what is should look like:

    Column A Column B
    Single s

    Now copy the s down the column to your last singular word ( I assume row 1000)

    In the example above, enter the formula =concatenate(a1,b1) in column C, row
    1.

    I think that is what you are looking for.
    "Mis" wrote:

    > Hi,
    > I'm looking to copy 1000 cells of singular form text into the next column
    > and make it plural. Is there a function to do that?
    >
    > Thanks in advance!


  3. #3
    Mis
    Guest

    RE: function in to make text plural?

    Thank you, thank you, thank you!! This saves me a lot of time.

    "Groovy_Kincaid" wrote:

    > Hi Mis,
    >
    > Try this:
    >
    > In the column to the right of your singular word, enter the letter s. This
    > is what is should look like:
    >
    > Column A Column B
    > Single s
    >
    > Now copy the s down the column to your last singular word ( I assume row 1000)
    >
    > In the example above, enter the formula =concatenate(a1,b1) in column C, row
    > 1.
    >
    > I think that is what you are looking for.
    > "Mis" wrote:
    >
    > > Hi,
    > > I'm looking to copy 1000 cells of singular form text into the next column
    > > and make it plural. Is there a function to do that?
    > >
    > > Thanks in advance!


  4. #4
    Gord Dibben
    Guest

    Re: function in to make text plural?

    Mis

    With this method you're going to have an awful lot of spelling mistakes, but if
    you're happy.....??


    Gord

    On Fri, 23 Jun 2006 14:01:02 -0700, Mis <Mis@discussions.microsoft.com> wrote:

    >Thank you, thank you, thank you!! This saves me a lot of time.
    >
    >"Groovy_Kincaid" wrote:
    >
    >> Hi Mis,
    >>
    >> Try this:
    >>
    >> In the column to the right of your singular word, enter the letter s. This
    >> is what is should look like:
    >>
    >> Column A Column B
    >> Single s
    >>
    >> Now copy the s down the column to your last singular word ( I assume row 1000)
    >>
    >> In the example above, enter the formula =concatenate(a1,b1) in column C, row
    >> 1.
    >>
    >> I think that is what you are looking for.
    >> "Mis" wrote:
    >>
    >> > Hi,
    >> > I'm looking to copy 1000 cells of singular form text into the next column
    >> > and make it plural. Is there a function to do that?
    >> >
    >> > Thanks in advance!


    Gord Dibben MS Excel MVP

  5. #5
    Ragdyer
    Guest

    Re: function in to make text plural?

    Why not 'hard code' the "s" in the formula, so that you don't need the
    additional column?

    Try this:

    =A1&"s"

    And copy down as needed.
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "Mis" <Mis@discussions.microsoft.com> wrote in message
    news:BE3405F8-DAFA-49EF-95AB-89BA8AFEB60A@microsoft.com...
    > Thank you, thank you, thank you!! This saves me a lot of time.
    >
    > "Groovy_Kincaid" wrote:
    >
    >> Hi Mis,
    >>
    >> Try this:
    >>
    >> In the column to the right of your singular word, enter the letter s.
    >> This
    >> is what is should look like:
    >>
    >> Column A Column B
    >> Single s
    >>
    >> Now copy the s down the column to your last singular word ( I assume row
    >> 1000)
    >>
    >> In the example above, enter the formula =concatenate(a1,b1) in column C,
    >> row
    >> 1.
    >>
    >> I think that is what you are looking for.
    >> "Mis" wrote:
    >>
    >> > Hi,
    >> > I'm looking to copy 1000 cells of singular form text into the next
    >> > column
    >> > and make it plural. Is there a function to do that?
    >> >
    >> > Thanks in advance!



  6. #6
    Chip Pearson
    Guest

    Re: function in to make text plural?

    This will still give wrong results. E.g, "box" -> "boxs",
    "entity"->"entitys"


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
    news:%23K2ndNxlGHA.4164@TK2MSFTNGP03.phx.gbl...
    > Why not 'hard code' the "s" in the formula, so that you don't
    > need the additional column?
    >
    > Try this:
    >
    > =A1&"s"
    >
    > And copy down as needed.
    > --
    > HTH,
    >
    > RD
    >
    > ---------------------------------------------------------------------------
    > Please keep all correspondence within the NewsGroup, so all may
    > benefit !
    > ---------------------------------------------------------------------------
    >
    > "Mis" <Mis@discussions.microsoft.com> wrote in message
    > news:BE3405F8-DAFA-49EF-95AB-89BA8AFEB60A@microsoft.com...
    >> Thank you, thank you, thank you!! This saves me a lot of
    >> time.
    >>
    >> "Groovy_Kincaid" wrote:
    >>
    >>> Hi Mis,
    >>>
    >>> Try this:
    >>>
    >>> In the column to the right of your singular word, enter the
    >>> letter s. This
    >>> is what is should look like:
    >>>
    >>> Column A Column B
    >>> Single s
    >>>
    >>> Now copy the s down the column to your last singular word ( I
    >>> assume row 1000)
    >>>
    >>> In the example above, enter the formula =concatenate(a1,b1)
    >>> in column C, row
    >>> 1.
    >>>
    >>> I think that is what you are looking for.
    >>> "Mis" wrote:
    >>>
    >>> > Hi,
    >>> > I'm looking to copy 1000 cells of singular form text into
    >>> > the next column
    >>> > and make it plural. Is there a function to do that?
    >>> >
    >>> > Thanks in advance!

    >




  7. #7
    Gord Dibben
    Guest

    Re: function in to make text plural?

    Doesn't seem to matter to Mis

    Gord

    On Fri, 23 Jun 2006 17:25:31 -0500, "Chip Pearson" <chip@cpearson.com> wrote:

    >This will still give wrong results. E.g, "box" -> "boxs",
    >"entity"->"entitys"


    Gord Dibben MS Excel MVP

  8. #8
    Ragdyer
    Guest

    Re: function in to make text plural?

    You're right Gord.
    The only reason I suggested it was because of the *very enthusiastic*
    acceptance of Groovy's solution.
    --
    Regards,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "Gord Dibben" <gorddibbATshawDOTca> wrote in message
    news:66ro925v64mntuhhagmqmvv23ao0r104ci@4ax.com...
    > Doesn't seem to matter to Mis
    >
    > Gord
    >
    > On Fri, 23 Jun 2006 17:25:31 -0500, "Chip Pearson" <chip@cpearson.com>
    > wrote:
    >
    >>This will still give wrong results. E.g, "box" -> "boxs",
    >>"entity"->"entitys"

    >
    > Gord Dibben MS Excel MVP



  9. #9
    Gord Dibben
    Guest

    Re: function in to make text plural?

    I'm just being picky these days RD.

    Ben cooped up since early February with some unspecified illness that seems to
    be abating.

    Getting better and feeling my oats.

    Looking for a fight<g>

    Be on the Golf Course by Mid-July I believe.


    Gord

    On Fri, 23 Jun 2006 16:25:04 -0700, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:

    >You're right Gord.
    >The only reason I suggested it was because of the *very enthusiastic*
    >acceptance of Groovy's solution.



  10. #10
    Gord Dibben
    Guest

    Re: function in to make text plural?

    Forgot how to spell also.

    BEEN cooped up

    On Fri, 23 Jun 2006 18:14:00 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

    >I'm just being picky these days RD.
    >
    >Ben cooped up since early February with some unspecified illness that seems to
    >be abating.
    >
    >Getting better and feeling my oats.
    >
    >Looking for a fight<g>
    >
    >Be on the Golf Course by Mid-July I believe.
    >
    >
    >Gord
    >
    >On Fri, 23 Jun 2006 16:25:04 -0700, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:
    >
    >>You're right Gord.
    >>The only reason I suggested it was because of the *very enthusiastic*
    >>acceptance of Groovy's solution.


    Gord Dibben MS Excel MVP

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1