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 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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" 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
...
Doesn't seem to matter to Mis

Gord

On Fri, 23 Jun 2006 17:25:31 -0500, "Chip Pearson"
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" 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" 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