+ Reply to Thread
Results 1 to 3 of 3

delete row if text length does not equal 7 or 4

  1. #1
    Registered User
    Join Date
    05-17-2020
    Location
    England
    MS-Off Ver
    home and student 2013
    Posts
    1

    delete row if text length does not equal 7 or 4

    Text is in Column B3:B3000 range. If the length of text in cell does not =7 or =4 then delete row. Any ideas please?

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    514

    Re: delete row if text length does not equal 7 or 4

    Use an extra column and the auto filter

    Please Login or Register  to view this content.
    Or place a sample file.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,179

    Re: delete row if text length does not equal 7 or 4

    C3 =IF(OR(LEN(B3)=7,LEN(B3)=4),"delete","") and drag down.

    After that filter on column C on delete and delete the visual rows.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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: 3
    Last Post: 12-07-2019, 04:50 AM
  2. Replies: 4
    Last Post: 01-31-2014, 05:09 PM
  3. Delete all characters of a certain length
    By LightingPop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2013, 12:26 PM
  4. concatenation of cells to equal length
    By udayg10 in forum Excel General
    Replies: 2
    Last Post: 04-01-2010, 09:55 AM
  5. [SOLVED] want to remove all text characters equal to one character in length from text string
    By tinalwalton@yahoo.co.uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2005, 05:06 PM
  6. want to remove all text characters equal to one character in length from text string
    By tinalwalton@yahoo.co.uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2005, 08:10 PM
  7. Count cells with length not equal to 7
    By cottage6 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-07-2005, 04:06 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