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