function in to make text plural?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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. :)
Click to expand...

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.
 
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
 
You're right Gord.
The only reason I suggested it was because of the *very enthusiastic*
acceptance of Groovy's solution.
 
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
 
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
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top