Need to make text plural??

[Mis]

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?

 

[Chip Pearson]

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

 

[Gord Dibben]

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