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!
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!
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!
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!
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 <[email protected]> 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
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" <[email protected]> wrote in message
news:[email protected]...
> 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!
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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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!
>
Doesn't seem to matter to Mis
Gord
On Fri, 23 Jun 2006 17:25:31 -0500, "Chip Pearson" <[email protected]> wrote:
>This will still give wrong results. E.g, "box" -> "boxs",
>"entity"->"entitys"
Gord Dibben MS Excel MVP
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:[email protected]...
> Doesn't seem to matter to Mis
>
> Gord
>
> On Fri, 23 Jun 2006 17:25:31 -0500, "Chip Pearson" <[email protected]>
> wrote:
>
>>This will still give wrong results. E.g, "box" -> "boxs",
>>"entity"->"entitys"
>
> Gord Dibben MS Excel MVP
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" <[email protected]> wrote:
>You're right Gord.
>The only reason I suggested it was because of the *very enthusiastic*
>acceptance of Groovy's solution.
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" <[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks