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?