+ Reply to Thread
Results 1 to 3 of 3

Exclude BLANKS and FORMULAE while pasting the data

  1. #1
    Registered User
    Join Date
    07-19-2018
    Location
    strasbourg,france
    MS-Off Ver
    2016
    Posts
    2

    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.

    =IF(ISBLANK(A1),"",A1*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
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    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.
    Regards
    Special-K

    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
    07-18-2018
    Location
    Bella, Kafr El Sheikh, Egypt
    MS-Off Ver
    16.0
    Posts
    6

    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

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