+ Reply to Thread
Results 1 to 3 of 3

Exclude BLANKS and FORMULAE while pasting the data

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Exclude BLANKS and FORMULAE while pasting the data

    Consider column_1 and column_2 has a range of 100. I input column_1 with numbers(float and integers) only till 50th row. Column_2 is associated with a certain formula linked to column_1. Now we can see that that Column_2 is have the formula linked till 100th row. My task is to copy column_1 till 100th row and paste in Column_3, but I want only values to be pasted and not the blanks. I also want to copy the column_2 values till 100th row, but neither the formulas nor the blanks I want to paste it in column_4.


    I have tried using the PASTE special options as only numbers and exclude blanks options, but failed to get the output. I also tried recording the macros for the same.

    Since I am using this sheet to save as a CSV file and export the data to python, I can see two quotes ' ' in the place of empty blanks. I don't want any blanks to be pasted and only numbers. Can anyone say what can be the solution.

    Thank you for the time.
    Last edited by AliGW; 07-19-2018 at 04:03 AM. Reason: Unnecessary code tags removed.

  2. #2
    Forum Expert
    Join Date
    London, England
    MS-Off Ver
    Excel 2019

    Re: Exclude BLANKS and FORMULAE while pasting the data

    Attach a file so we can see exactly what the data contains, provide an end result of what you expect the data to look likle.
    If necessary create a mockup.

    Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    Bella, Kafr El Sheikh, Egypt
    MS-Off Ver

    Re: Exclude BLANKS and FORMULAE while pasting the data

    According to my understanding: If you want to move the data column 1 to column 2 without calculating the blanks
    Use the following formula and press Ctrl+Shift+Enter
    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)

Similar Threads

  1. SUMPRODUCT + COUNTIF but exclude blanks
    By finnvalor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2017, 03:50 PM
  2. [SOLVED] Change Formulae to show blanks/no data
    By Keshypops in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2016, 03:36 PM
  3. Exclude Blanks
    By excelnoob927 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2015, 06:53 PM
  4. Make if formulae ignore blanks
    By superdaw in forum Excel General
    Replies: 4
    Last Post: 09-18-2014, 10:12 AM
  5. Exclude blanks from formula
    By ads100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2012, 06:17 PM
  6. Excel 2007 : MIN, AVE, MAX values but exclude blanks
    By Quagga in forum Excel General
    Replies: 7
    Last Post: 07-15-2010, 02:29 PM
  7. Replies: 3
    Last Post: 10-22-2007, 01:41 PM

Tags for this Thread


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