|
|
#2
03-08-2012, 12:44 PM
|
||||
|
||||
As you suspected your cells contain null strings
If you enter Code:
=istext(b2) So, you can select these cells, click "delete". They are now blank cells
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Empty cells plotted as zero. | ColinC | Excel | 2 | 01-23-2012 08:02 AM |
 Vba, Is there a better way to test empty cells?
|
Hwyn | Excel Programming | 2 | 11-14-2011 11:44 AM |
|
Empty rules
|
rene.kamphuis@ciz.nl | Mail Merge | 21 | 04-15-2011 12:34 AM |
| Shared Calendar Empty | worksmart | Outlook | 0 | 01-21-2011 06:32 AM |
| Populate an empty .PAB file | imported_contiw | Outlook | 2 | 08-17-2006 08:50 PM |
Windows XP 
Office 2003
Threaded Mode