+ Reply to Thread
Results 1 to 2 of 2

Remove cells with invalid data

  1. #1
    Registered User
    Join Date
    09-02-2021
    Location
    Amsterdam
    MS-Off Ver
    16.52
    Posts
    1

    Lightbulb Remove cells with invalid data

    Hello,

    I have a huge list of words, to which I have applied Data Validation so I could see all the words that have a character limitation (2 minimum, 8 maximum). I can see the circled words now, but is there a way I can remove all of these cells at once, so I don't have them anymore on my list of words?

    Thank you!

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Remove cells with invalid data

    Hi josendozer:
    Welcome to the forum.

    If these to be removed cell contents are all in a single column, apply a filter to the soon to be departed values.
    Highlight the range, press F5, special, visible cells only, OK, then your delete key. Does that work for you?

    Pete

+ 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. Prevent copy and paste invalid data for data validation cells
    By inoka in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-04-2018, 04:15 AM
  2. [SOLVED] Need to remove invalid data
    By tsdpurdue in forum Excel General
    Replies: 2
    Last Post: 02-11-2016, 06:28 AM
  3. [SOLVED] Remove Invalid Value from Sum Function
    By momer in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-20-2013, 10:28 AM
  4. Data validation - How to get Invalid cells - VBA
    By richard.briggs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2013, 11:12 AM
  5. Formula to remove invalid times?
    By russianspd in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-07-2011, 05:25 PM
  6. Counting cells with Invalid Data
    By Brad E. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2006, 01:35 PM
  7. Remove Invalid Phone Numbers
    By indyadmin1974 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2005, 06:05 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