Remove cells with text not relevant

[Paal]

I have a spreadsheet containing in Column A the following:

ABC Total
ABC
ABC
ABC
ABC
DEF Total
DEF
DEF
DEF
DEF
etc.

I want to keep just the cells containing XXX Total, i.e. skip all cells
with only XXX. Any suggestions how to get rid of cells not containg
"Total"?

Thanks,
Paal

 

[Guest]

Hi Paal,

If you want only hide the unwanted rows:

Autofilter/Unique (or specific, I don't know which English word is used,
because I use Hungarian version, the third option after All and Rank), select
"contains" (left field) and give Total (right field).

If you want remove the unwanted rows:

same as above, except "doesn't contain" instead of "contains",
then select all cells (click on upper left corner) and Edit/Delete

Regards,
Stefi



„Paal†ezt írta:

 

[Paal]

Thanks Stefi, your idea with using filter is good.

Still, I wonder if it's possible to use a formula saying keep cell
containing two words, and remove cells containing one word. Mayb
something like IF (followed by the condition) and then SUBSTITUE o
REPLACE