+ Reply to Thread
Results 1 to 4 of 4

Is there a way to delete the rows which column A value match a certain regex?

  1. #1
    Forum Contributor
    Join Date
    08-01-2016
    Location
    China, beijing
    MS-Off Ver
    2016
    Posts
    114

    Is there a way to delete the rows which column A value match a certain regex?

    As the title says. I already upload the file. Sry for that.

    In the sample sheet I want to delete the line which value is "hello", "world". If the sheet is large, it must be done in VBA. The value may be more complicated, I want to use regex (For example ".*o.*") to match the rows and then delete them. How to make it?
    Attached Files Attached Files
    Last edited by woshichuanqilz; 04-18-2017 at 06:50 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,748

    Re: Is there a way to delete the rows which column A value match a certain regex?

    Please, as you have been asked before, give more details and provide some sample data showing your layout and what you wish to achieve. Thanks!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    08-01-2016
    Location
    China, beijing
    MS-Off Ver
    2016
    Posts
    114

    Re: Is there a way to delete the rows which column A value match a certain regex?

    I rewrite the post.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Is there a way to delete the rows which column A value match a certain regex?

    Maybe:

    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. VBA macro to match information from one column with another and delete rows no match
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-17-2016, 04:07 PM
  2. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  3. [SOLVED] If certain columns in a row match the rows beneath then sum a specifc column and delete
    By wbrown in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2012, 12:01 PM
  4. Delete Rows that do not match
    By JahJr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 10:22 AM
  5. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  6. [SOLVED] REGEX to delete all non hex characters
    By creeves95833 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2012, 05:43 PM
  7. Sort Column, Delete Rows, Delete Column, Move Molumn, more inside?
    By motown in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2008, 09:44 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1