Now how to delete plurals??

[Mis]

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

[Elkar]

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

[Mis]

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

[amit87]

hi thanks for solution
i need one help in this
i dont want to delete purals. i just want to highlights those
is it possible?

[SDCh]

Hi amit87

Please read Forum Rule:
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Regards