+ Reply to Thread
Results 1 to 3 of 3

Extracting Only Non-Blanks

  1. #1
    Registered User
    Join Date
    11-07-2018
    Location
    Minnesota
    MS-Off Ver
    Office 365 ProPlus Version 1708
    Posts
    6

    Extracting Only Non-Blanks

    Hello all,

    I am searching for a formula that will only extract the non-blank cells within a column. I would like to extract the non-blanks in column X and place them in column Y as below. An example of my data is below

    X Y
    - 1234
    - 1235
    1234 1236
    1235 1237
    1236 1238
    - ...
    1237
    -
    1238
    ...

    If there is not a formula but an easier way that would be great too. Thank you for your help.
    Last edited by spudder6; 11-20-2018 at 12:28 PM. Reason: Added sample file

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    20,992

    Re: Extracting Only Non-Blanks

    will you define non blanks? Are you looking for cells that contain values? What if there is a formula but the cell shows no values? Are you asking for non-null values. Please clarify. You might be better served if you upload a sample worksheet with before and after scenarios to make sure we understand what you mean by non-blank
    Alan


    Have you debugged your code?
    Database Normalization
    What is Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Extracting Only Non-Blanks

    Sure you can do this with a formula but here's a simpler way:

    Copy and paste column X into column Y > with column Y selected go to Find & Select > Go To Special > Blanks > OK

    Now right-click on any of the selected cells > Delete > Shift cells up

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to count blanks and non-blanks with a dynamic range
    By brittdyer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-12-2018, 07:45 AM
  2. Replies: 9
    Last Post: 05-22-2018, 10:37 AM
  3. BLANKS (Not Really Blanks) AND Rearrange ignoring blanks
    By shivspatil in forum Excel General
    Replies: 4
    Last Post: 02-02-2018, 08:28 AM
  4. [SOLVED] Access Query shows (Blanks) but no blanks in data!
    By MissDB in forum Access Tables & Databases
    Replies: 0
    Last Post: 09-08-2016, 07:16 AM
  5. VBA code finds blanks, but how to write VBA to ignore non blanks?
    By hopegriffin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2016, 10:51 AM
  6. [SOLVED] How to convert a horizontal vector with blanks into a vertical one without blanks
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2014, 02:55 PM
  7. [SOLVED] Paste Special Skip Blanks not skipping blanks, but overwriting...
    By gsrosin in forum Excel General
    Replies: 0
    Last Post: 02-22-2005, 12:06 AM

Tags for this Thread

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