Hello All,

I have a huge spreadsheet (that started as a text file) that I am
trying to edit for two conditions separately:
1)  How do I delete entire rows having the text "Jackpot" among its
contents.
2) Is there a way to find and delete all text or characters falling
between two :'s.
Example- cell B6 contains [men: over 25: wear red], how do I delete
the text falling between ":" and ":" , in this case "over 25".  It can
be "over 50"  but the formatting is the same.

Could a macro be used?  I found some on the net but they did not do
the job.

Many thanks for any help.

Mac