+ Reply to Thread
Results 1 to 6 of 6

delete cells with particular text

  1. #1
    Registered User
    Join Date
    01-18-2014
    Location
    bangalore, india
    MS-Off Ver
    Excel 2010
    Posts
    14

    delete cells with particular text

    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.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: delete cells with particular text

    1. do you want the cells cleared or deleted?
    2. does the cell contain only banana or banana as part of a string?
    Gary's Student

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: delete cells with particular text

    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

  4. #4
    Registered User
    Join Date
    01-18-2014
    Location
    bangalore, india
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: delete cells with particular text

    i want the cells to be deleted completely.

    the cell may include banana with variety name also.

  5. #5
    Registered User
    Join Date
    01-18-2014
    Location
    bangalore, india
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: delete cells with particular text

    using filter is tedious if the number of different items in the list are numerous,
    and the filter list becomes too long to handle.

  6. #6
    Registered User
    Join Date
    09-28-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: delete cells with particular text

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search for red filles cells or certain text strings cells in Column A and delete row.
    By The Skipper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2013, 12:57 PM
  2. [SOLVED] Delete Unwanted Text in Cells
    By saeed9313 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2012, 09:30 PM
  3. [SOLVED] Delete part of a text in cells.
    By Jeffy14 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-15-2012, 02:36 PM
  4. Delete cells that contain text
    By ChrisKader in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-15-2010, 08:57 PM
  5. Delete all cells containing certain text
    By kilanw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2009, 03:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1