Deleting Rows

[OldMac77]

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

 

[Don Guillett]

1. Use data>filter>autofilter>filter the column ="Jackpot">delete
2. use FIND formula or INSTR macro.

 

[OldMac77]

1. Use data>filter>autofilter>filter the column ="Jackpot">delete
2. use FIND formula or INSTR macro.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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- Hide quoted text -

- Show quoted text -

Don,

Thank you Sir.
After some trying I used "Auto Filter" and combinations of MID/FIND
and REPLACE/SEARCH to organize the data.

Mac

 

[Don Guillett]

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

1. Use data>filter>autofilter>filter the column ="Jackpot">delete
2. use FIND formula or INSTR macro.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
message

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- Hide quoted text -

- Show quoted text -

Don,

Thank you Sir.
After some trying I used "Auto Filter" and combinations of MID/FIND
and REPLACE/SEARCH to organize the data.

Mac