Now how to delete plurals??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mis - 23 Jun 2006 22:16 GMT

If I have a ton of phrases listed, some singular and some plural form in
separate cells of one column, listed like below, is there a way to delete the
plural versions quickly and keep the singular without spaces inbetween the
cells (where the plural forms used to be)? If it helps, a lot of the plural
phrases do end with 'costumes' so I'm dealing mainly with the same word.

halloween costume
halloween costumes
pet costume
pet costumes
anakin skywalker costume
anakin skywalker costumes

Thanks for any feedback you can give,
Mis

Reply to this Message

Elkar - 23 Jun 2006 22:35 GMT

If removal of an ending S is what you're looking for, then this formula
should do the trick:

=IF(RIGHT(A1,1)="S",MID(A1,1,LEN(A1)-1),A1)

This assumes your data starts in A1. If not, then change to match your needs.

HTH,
Elkar

> If I have a ton of phrases listed, some singular and some plural form in
> separate cells of one column, listed like below, is there a way to delete the
[quoted text clipped - 11 lines]
> Thanks for any feedback you can give,
> Mis

Reply to this Message

Mis - 23 Jun 2006 23:09 GMT

Elkar,

That worked. And I finished it off with a pivot table to eliminate
duplicates.

Thanks a bunch!
Mis

> If removal of an ending S is what you're looking for, then this formula
> should do the trick:
[quoted text clipped - 21 lines]
> > Thanks for any feedback you can give,
> > Mis

Reply to this Message