Pluralize

  • Thread starter Thread starter aselunar
  • Start date Start date
A

aselunar

Is there a function to pluralize text in a cell? For example =PLURALIZE(e21)
or something like that?
 
Is there a function to pluralize text in a cell? For example =PLURALIZE(e21)
or something like that?
Click to expand...

I think the best you could do is to either create a table of singular
and plural forms of nouns and run vlookups, or simply add an "s" to
the end of each word.
 
OK vlookups, I'll try that. Thanks. Luckily I think I have a finite number of
words that will need to be pluralized.

Side note: But gosh there must be some people that have to work with plurals
of lots of things... for those people maybe Microsoft should put a function
in the next version that pluralizes things using rules of a third grade
grammar book... or at least a function that adds an s to the ends of words.
 
aselunar said:
OK vlookups, I'll try that. Thanks. Luckily I think I have a finite number
of
words that will need to be pluralized.

Side note: But gosh there must be some people that have to work with
plurals
of lots of things... for those people maybe Microsoft should put a
function
in the next version that pluralizes things using rules of a third grade
grammar book... or at least a function that adds an s to the ends of
words.
Click to expand...

You're vastly underestimating the complexity and variation of plural
formation in the English language.
 
WASHINGTONS -
Presidents Bushs sought to presents
a united global fronts
in responding to the financial crisiss
on Saturday, saying the world'ss
leading industrialized countriess
had agreed on common steps to stabilize the markets
and shore up the bankings systems.

"All of us recognize that this
is a serious global crisiss,
and therefore requires a serious global responses,
for the goods of our peoples,"
Mr. Bush said after an early-morning meetings
at the White Houses with
finance ministers from the Groups of 7 countries.
 
alan wrote:>
You're vastly underestimating the complexity and variation of plural
formation in the English language.
Click to expand...

Add to that all the other languages......
Mike
 
No I'm not underestimating the complexity and variation. I will still
proofread a sheet to make sure it is gramatically correct. But manually
adding or subtracting an s to cell after cell can get tedious.
 
Back
Top