Remove cells with text not relevant
 

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


--
Paal
------------------------------------------------------------------------
Paal's Profile: http://www.excelforum.com/member.php...o&userid=26873
View this thread: http://www.excelforum.com/showthread...hreadid=401095

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:


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


--
Paal
------------------------------------------------------------------------
Paal's Profile: http://www.excelforum.com/member.php...o&userid=26873
View this thread: http://www.excelforum.com/showthread...hreadid=401095

Thanks Stefi, your idea with using filter is good.

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


--
Paal
------------------------------------------------------------------------
Paal's Profile: http://www.excelforum.com/member.php...o&userid=26873
View this thread: http://www.excelforum.com/showthread...hreadid=401095