+ Reply to Thread
Results 1 to 12 of 12

Delete blanks from Column

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Delete blanks from Column

    Hello all,

    I've got a table of data on Sheet4. There is the occasional blank in Column P.

    I want to be able to select Column P on Sheet4 and then copy this column to C2 in Sheet1, with the blanks being filtered out.

    Is this possible?

  2. #2
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Re: Delete blanks from Column

    It would appear that in my spreadsheet these cells are not actually blanks, as when I highlight a group of them it still counts them (i.e. I highlight 6 cells with nothing in them and it shows count as 6 in the corner).

  3. #3
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    5,095

    Re: Delete blanks from Column

    It would help if you could supply a copy of your workbook.

  4. #4
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Re: Delete blanks from Column

    I have attached a test workbook.

    The majority of the data has been removed, so it does look quite bare.

    The data I am having issue with is the column in Sheet4. There is one blank in there, which will not delete.

    I am trying to get this column to copy from Sheet4 into Sheet1, with the blank being removed. But it appears that excel does not recognise this as a blank.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Re: Delete blanks from Column

    I will add that the range is dynamic, so at times there could be more or less values in that column on Sheet4.

  6. #6
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    5,095

    Re: Delete blanks from Column

    This works for me
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Re: Delete blanks from Column

    Wonderful, that works perfectly!

  8. #8
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    5,095

    Re: Delete blanks from Column

    You're welcome & thanks for the feedback

  9. #9
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Re: Delete blanks from Column

    How does it work? As the blank cells aren't actually blank in my spreadsheet.

  10. #10
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    5,095

    Re: Delete blanks from Column

    The autofilter still sees them as blank, so I took the easiest option & used that.

  11. #11
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    365

    Re: Delete blanks from Column

    Ok cool. I have a countifs formula on a worksheet that doesn't work because of the issue. It is supposed to count the blanks, but it doesn't because excel doesn't not recognise them as blank.

  12. #12
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    5,095

    Re: Delete blanks from Column

    In that case how about
    Please Login or Register  to view this content.

+ Reply to Thread

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