+ Reply to Thread
Results 1 to 2 of 2

Find and clear contents

  1. 02-11-2017, 03:07 AM #1
    kprabhupaul
    kprabhupaul is offline
    Forum Contributor
    Join Date
    06-02-2016
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    327

    Find and clear contents

    Dear All,

    How to find all the cells with value "0" in a sheet and clear contents from all of those cells ..?

    Thank You
    Reply With QuoteRegister To Reply
  2. 02-11-2017, 04:08 AM #2
    AliGW
    AliGW is online now
    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,779

    Re: Find and clear contents

    Use Find and Replace!

    Find: 0
    Replace: (blank box)
    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.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Find string and clear cell contents to the right
    By Johnatha in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-11-2016, 03:23 PM
  2. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  3. clear contents of entire sheet except the contents of the table
    By wayneg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2015, 08:41 AM
  4. Macro - find cells row by row, clear contents if certain value in cells
    By astrbac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2014, 05:34 AM
  5. How can i find all duplicates in 3 columns and clear contents in all but first column A
    By the duke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2014, 08:44 PM
  6. [SOLVED] Clear contents based on contents of another cell
    By Katrina DTE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2013, 02:44 PM
  7. Clear sheet contents but retain Clipboard contents
    By nebb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2007, 01:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1