function in to make text plural?

[Mis]

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!

 

[Groovy_Kincaid]

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]

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

 

[Gord Dibben]

Mis

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


Gord

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

Gord Dibben MS Excel MVP

 

[Ragdyer]

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.

 

[Chip Pearson]

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

 

[Gord Dibben]

Doesn't seem to matter to Mis

Gord

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

Gord Dibben MS Excel MVP

 

[Ragdyer]

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

 

[Gord Dibben]

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

 

[Gord Dibben]

Forgot how to spell also.

BEEN cooped up

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

Gord Dibben MS Excel MVP