+ Reply to Thread
Results 1 to 2 of 2

Delete multiple cells that contains words

  1. 08-09-2013, 09:57 AM #1
    gilboston2013
    gilboston2013 is offline
    Registered User
    Join Date
    08-09-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    1

    Delete multiple cells that contains words

    Let's say I have a thousand of cell as:
    a1 maria
    a2 john
    a3 adam
    a4 mary
    a5 bobby

    How to delete cells containing the words John mary and maria for example and keep all others?
    In this case I would delete cells: a1 a2 and a4
    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 08-09-2013, 10:01 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Delete multiple cells that contains words

    Hi,

    Can you not just filter the column for those names that you don't want to keep and then delete the rows?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Besides manually how can I delete words in multiple rows?
    By Kelly P. in forum Excel General
    Replies: 3
    Last Post: 08-18-2014, 06:28 PM
  2. [SOLVED] Delete repeated words in every cells in a Range
    By mmtoure in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-14-2013, 07:02 AM
  3. [SOLVED] Find and delete multiple words
    By jeybe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2013, 12:23 PM
  4. Delete blank row above cells with specific words.
    By beyre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2012, 02:17 AM
  5. Delete a Row if a cells contains specific words
    By jsolder in forum Excel General
    Replies: 1
    Last Post: 08-14-2009, 05:36 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1