+ Reply to Thread
Results 1 to 3 of 3

How to delete entire row if text string from first column match text string from text file

  1. #1
    Registered User
    Join Date
    05-26-2016
    Location
    edmonton
    MS-Off Ver
    2010
    Posts
    2

    How to delete entire row if text string from first column match text string from text file

    Hello
    I have a text file called del.log
    del.log sample:
    STRING1
    STRING2
    STRING3

    Also I have excel sheet with almost 1 000 000 rows in it. I'm looking for a EFFECTIVE way how to delete entire row if text string in column A exactly matches one of text strings from del.log file?

    Thank you for any suggestions.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,253

    Re: How to delete entire row if text string from first column match text string from text

    This should work in 2010.
    It does not work in 2007 because of the 8192 limit for SpecialCells.
    Please Login or Register  to view this content.
    Greetings from Sherwood Park

  3. #3
    Registered User
    Join Date
    05-26-2016
    Location
    edmonton
    MS-Off Ver
    2010
    Posts
    2

    Re: How to delete entire row if text string from first column match text string from text

    Thank you for your help. It works however I need somehow read those strings from external file del.log and delete rows based on strings saved in del.log file.

+ 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. Replies: 2
    Last Post: 05-14-2015, 01:30 PM
  2. [SOLVED] Find partial text string within another text string return original text into cell.
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-17-2013, 02:58 PM
  3. copy only fonts(text color) from one string of text to another string of text
    By JMJ123 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 04:22 AM
  4. [SOLVED] Macro to Search column for Text string and Copy Entire Row to another Worksheet
    By TJacks1908 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 07:11 AM
  5. Search text string for range of text values - return match
    By crugg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2010, 09:55 AM
  6. [SOLVED] Match row that contains text text string; list associated values from pivot table
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2009, 07:50 PM

Tags for this Thread

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