Results 1 to 19 of 19

Can't clear non-blank empty cells

Threaded View

jomili Can't clear non-blank empty... 12-10-2010, 11:22 AM
solnajeff Re: Can't clear non-blank... 12-10-2010, 11:24 AM
jomili Re: Can't clear non-blank... 12-10-2010, 11:26 AM
ChemistB Re: Can't clear non-blank... 12-10-2010, 11:43 AM
jomili Re: Can't clear non-blank... 12-10-2010, 12:02 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 12:05 PM
jomili Re: Can't clear non-blank... 12-10-2010, 12:10 PM
jomili Re: Can't clear non-blank... 12-10-2010, 12:15 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 12:08 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 12:11 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 12:55 PM
jomili Re: Can't clear non-blank... 12-10-2010, 01:04 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 01:18 PM
jomili Re: Can't clear non-blank... 12-10-2010, 01:50 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 01:54 PM
jomili Re: Can't clear non-blank... 12-10-2010, 01:57 PM
Tony2Toes Re: Can't clear non-blank... 02-09-2016, 01:42 PM
ChemistB Re: Can't clear non-blank... 12-10-2010, 02:15 PM
newdoverman Re: Can't clear non-blank... 02-09-2016, 02:51 PM
  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,056

    Can't clear non-blank empty cells

    See the attached worksheet. What I WANT to do is, in columns A and B, do an Edit/GoTo/Special/Blanks, CtrlEnter to select all, =, up arrow, enter to paste the value above in all of the blank cells. The problem is all of my blank cells appear to be non-blank. I've tried using the TRIM function on them, the CLEAN function, copy and paste as values, etc. Can anyone help me to replace the non-empty blank cells with empty blank cells? Thanks in advance.
    Attached Files Attached Files
    Last edited by jomili; 12-10-2010 at 01:57 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