Is it possible to delete cells that contain a particular text in a long list containing alpha-numeric values.
eg:
In a list of fruits available, is it possible to delete only the cells with bananas.
hope iam making it clear.
bye & thnks in advance.
Is it possible to delete cells that contain a particular text in a long list containing alpha-numeric values.
eg:
In a list of fruits available, is it possible to delete only the cells with bananas.
hope iam making it clear.
bye & thnks in advance.
- do you want the cells cleared or deleted?
- does the cell contain only banana or banana as part of a string?
Gary's Student
Use autofilter to show only cells containing (text filters) banana and then delete visible cells, or delete visible rows if you want to "move up" data, leavinng no blank cells in places where bananas were found.
Best Regards,
Kaper
i want the cells to be deleted completely.
the cell may include banana with variety name also.
using filter is tedious if the number of different items in the list are numerous,
and the filter list becomes too long to handle.
Here's some VBA to do it.
Remove .EntireRow if you only want to delete the cells.
I use this snippet regularly due to the generic flexibility. When it prompts you for the range, enter it in the structure of "A1:A10" without the quotes.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks