Now how to delete plurals??
 

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

Now how to delete plurals??
 

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




"Mis" wrote:

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

Now how to delete plurals??
 

Elkar,

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

Thanks a bunch!
Mis

"Elkar" wrote:

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




"Mis" wrote:

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