Results 1 to 3 of 3

Remove row where a cell value = --

Threaded View

  1. 04-22-2015, 06:50 AM #1
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    318

    Remove row where a cell value = --

    Hi Guys
    I have a sheet where there are -- inserted to fill blank cells. I now want to remove any rows that have these but even if I use find and replace it can't see them. Has anyone any ideas. Note in C 20 in the summary sheet.

    Thanks

    Mark
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to take value of cell, remove specific text from it, then place it in active cell
    By ks100 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-03-2014, 02:28 PM
  2. [SOLVED] Check for existing cell values in another cell and remove them + 1 character.
    By ali.whitaker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2013, 06:17 AM
  3. macro need to be created to remove the duplicates from the cell andkeep cell as blank
    By vjnvinod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2011, 12:37 PM
  4. [SOLVED] Excel 2007 : Remove unwanted cell fill from blank cell
    By tradersteve in forum Excel General
    Replies: 4
    Last Post: 09-21-2010, 03:45 AM
  5. Get Excel to automatically change cell ref in a cell when I add/remove rows
    By Pamby in forum Excel General
    Replies: 5
    Last Post: 07-14-2009, 10:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1