+ Reply to Thread
Results 1 to 3 of 3

Deleting rows based on partial word in certain column

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    austin, tx
    MS-Off Ver
    office 11 for mac
    Posts
    2

    Deleting rows based on partial word in certain column

    I am trying to delete entire rows that have the words "admin" "sales" and "support" as part of their email addresses in column B. Could somebody help me out please?


    Thank you

  2. #2
    Forum Contributor stephenloky's Avatar
    Join Date
    07-10-2013
    Location
    Sao Paulo - Brazil
    MS-Off Ver
    Excel 2007
    Posts
    146

    Re: Deleting rows based on partial word in certain column

    Make a macro that will loop thru all lines and if it find the words in the phrase just (assuming i is your line number)
    Please Login or Register  to view this content.
    "The quieter you become, the more you are able to hear"

    Any reputation (*) points appreciated.

    "If you know yourself but not the enemy, for every victory gained, you will suffer defeat."

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Deleting rows based on partial word in certain column

    Try:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 03:52 PM
  2. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:02 PM
  3. [SOLVED] Deleting first word on all rows in column 1 ?
    By Kai in forum Excel General
    Replies: 6
    Last Post: 09-06-2012, 04:09 PM
  4. Deleting Partial Content in a Column
    By luu980 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-09-2009, 03:58 PM
  5. Deleting rows based upon partial cell text
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2008, 10:29 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