#1
|
|||
|
|||
Apparently empty (blank) cells aren't empty
I exported an access database to an excel spreadsheet. In one of my columns, I need to select or 'go to' all blank fields so that I can then copy data from above field into them. Problem is, the fields (shown below; actual file attached as well) appear blank, but they aren't. So when I select the column and choose 'Edit | Go To | Special | Blanks | Ok', no blank fields are recognized.
I read on another site's thread that possibly when exporting empty fields in access file to excel, there is in fact a null string there rather than it actually being empty and this may be spaces. I am hoping there's a way to possibly identify the true contents of these supposedly blank cells and then to truly empty/clear the contents. Or, I could find all cells that have these invisible characters and 'go to' them & then do my copy step. Any ideas? Thanks, John |
#2
|
||||
|
||||
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
__________________
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 |
#3
|
|||
|
|||
I failed to mention that the actual spreadsheet I'm wanting to select and delete null strings from is 1,947 records long with actual $$ amounts intermittently sprinkled throughout. Are there any shortcuts rather than manually selecting/highlighting all of these cells?
|
#4
|
|||
|
|||
Issue resolved; I was able to select my range and run this code:
Sub test() With Selection .Value = .Value End With End Sub |
Thread Tools | |
Display Modes | |
|
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 |