Results 1 to 10 of 15

Thread: Remove Unprintable Non-Blank Cells Having Zero Length Contents

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-01-2013, 02:20 PM #1
    aaronb
    aaronb is offline
    Junior Member
    Join Date
    May 2013
    Posts
    20
    Rep Power
    0

    Remove Unprintable Non-Blank Cells Having Zero Length Contents

    Hi,

    I'm importing data into a spreadsheet and what are supposed to be blank cells actually aren't. ISBLANK returns false. CODE(cellref) returns #VALUE error -- in the calculation steps, it looks like CODE( ""). TRIM(cellref) doesn't return a blank cell. Neither does CLEAN(cellref).

    "Clear contents" works.

    It was imported from a csv.

    Any ideas?
    Last edited by aaronb; 08-01-2013 at 02:33 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. How can I make MLOOKUP to ignore blank cells?
    By radionut in forum Excel Help
    Replies: 1
    Last Post: 07-22-2013, 09:18 AM
  2. How To Remove or Delete Blank Or Empty Rows After Data Is Transferred
    By jeff in forum Excel Help
    Replies: 5
    Last Post: 07-11-2013, 07:31 AM
  3. Delete All Empty Cells From Range Using VBA / Remove Blank Cells Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 13
    Last Post: 06-10-2013, 09:05 AM
  4. Remove Entire Row of Blank Cells in Column, Autofilter non-empty non-blank cells
    By sanmaya in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 11:19 PM
  5. Highlighting Blank Cells
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 08-13-2012, 07:56 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