Results 1 to 7 of 7

delete row based on criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2019
    Posts
    244

    delete row based on criteria

    hello,
    I have some datas :
    DRB1obed
    GRC2vecera
    ranajky
    olovrant

    and I need this : If first 3 characters are capital letter followed by number then do nothing, but if not then delete whole row ... it means after macro (or function?) result should be :
    DRB1obed
    GRC2vecera

    thanks for any help !
    Last edited by miso.dca; 01-02-2010 at 04:45 PM.

Thread Information

Users Browsing this Thread

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

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