Group,
I have a large spreadsheet that contains a single column. The
column is about 128 characters wide. I need to delete all rows that do
not contain the text %Name = "Lock Audio". Instead of deleting, I'm
trying to preserve cell contents that have the text. Also, all those
rows that contain %Name = "Lock Audio" , if the empty rows could be
deleted also. Thank you in advance.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=540094