Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Import - Clean Blank Data (Excel 2003)

    I have exported tables and query tables from an Access 2003 database into Excel to leverage the Excel functionalities. As I am doing a simple COUNTA function on the columns, it is counting blank cells. When I click on those cells to check what value (a space maybe), nothing is there. The COUNTA function won't stop counting the blank cell unless I press F2 while on the cell or Delete. How can I get a cleaner export or what is the fastest way to clean up the file and ensure blank cells are truly blank?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Import - Clean Blank Data (Excel 2003)

    You already asked this in the Access forum and I posted a reply there. To prevent further duplication, I'm locking this thread. Please post all replies in the thread starting at <post:=664,378>post 664,378</post:>.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •