Welcome to the MrExcel board!
Can you tell us a bit more about what you have and what you are trying to achieve? For example ..
- Can the text "30 mins" be part of larger text in a cell (eg "I will be back in 30 mins or less") or will it be the only text in a cell?
- Can the text be in any column or row, or should we be only looking in certain columns/rows (eg columns B and G, from row 2 down)?
- Could we have a small set of dummy data and the expected results? My signature block below has a link with good methods for doing that.
That just leaves one of my questions ...HI Peter
Yes it is a part of a larger text
Text could be in any column or Row
Thanks
- Could we have a small set of dummy data and the expected results? My signature block below has a link with good methods for doing that.
That just leaves one of my questions ...
You can't. If you followed the Look here link in my signature block as suggested, it tells you that but offers several alternative ways of posting sample data.Sorry I could not Figure out how to attached a file.
Has your requirement changed? Originally it was rows and columns that did not contain that text:Just want to delete entire row if that row does not have word "30 mins".
I have an excel worksheet where i want to delete everything except rows and columns that contain word "30 mins".
If it is rows and columns, then I would like to see a small set of representative dummy sample data before and after the deletions so that I am sure I am not wasting my time heading in the wrong direction - which I could easily have been if I followed what you said in post 6.Sorry it got a be rows and columns. Thanks