+ Reply to Thread
Results 1 to 2 of 2

Scan a Column A (numbers and blanks) and copy its contents WITHOUT BLANKS into Column B

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    22

    Scan a Column A (numbers and blanks) and copy its contents WITHOUT BLANKS into Column B

    I'm assuming that what I'm requesting requires me to mess around with VB.. (although it's always frustrating for me).

    My Column A contains numbers but some cells contain nothing (or technically, they contain --> "").
    Is there a code that can constantly be "looking" at Column A and copy & pasting (values) its contents into Column B BUT WITHOUT ANY OF THE BLANKS?

    Example..

    Column A will look like this:

    1
    2
    3
    [BLANK]
    4
    [BLANK]
    5

    And thus, the first five rows of Column B will be filled in with numbers.
    Last edited by bighandsam; 07-12-2012 at 04:34 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Scan a Column A (numbers and blanks) and copy its contents WITHOUT BLANKS into Column

    This website shows how it can be done using an array formula in column B (you will need a header row as well):

    http://www.get-digital-help.com/2009...om-one-column/

    Hope this helps.

    Pete

+ 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