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!