I have about 1000 cells in one column full of singular form text (all various
phrases and words) that I need to copy into the next column over, and change
into plural form. Is there a function that can quickly do this?

There is no good way to do this. Simply adding an 'S' won't work,
e.g., "boxes" would come out as "boxs".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mis" wrote in message
...
I have about 1000 cells in one column full of singular form text
(all various
phrases and words) that I need to copy into the next column
over, and change
into plural form. Is there a function that can quickly do
this?

A really good third-party Grammar application may be able to get you some
results, but Excel cannot do the job.

Too complex.

For one.....how would you treat the changeover from singular possessive to
plural possessive?

For two.........mine to theirs.


Gord Dibben MS Excel MVP

On Fri, 23 Jun 2006 13:14:02 -0700, Mis wrote:

I have about 1000 cells in one column full of singular form text (all various
phrases and words) that I need to copy into the next column over, and change
into plural form. Is there a function that can quickly do this?