+ Reply to Thread
Results 1 to 2 of 2

Pasting from google sheets into excel skips empty cells and "" results

  1. #1
    Registered User
    Join Date
    01-03-2015
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    55

    Pasting from google sheets into excel skips empty cells and "" results

    Hi gurus

    I have an online form that makes a spreadsheet in google sheets but as we all know excel rules, so i paste the data into an excel.
    A recent problem (though i've made no changes on purpose) is that now when i paste, it ignores & skips out any blanks

    Hence if i copy the answers to Questions 1 to 5, but only questions 1, 3 & 5 are answered, it just pastes the answers 1, 3 & 5 as if they are answers 1, 2 & 3, and as my excel has loads of formulae to interpret the answers, everything is a confused mess.

    I should also note that as there is some transposing and workings within google sheet, I'm copying formulae results from google sheets, and it is excel is ignoring values of this type :
    =if(1=0, "how odd!" , "")

    but i've checked and pasting in excel behaves the same even if i'm copying values rather than formulas from google sheets...

    Can anyone help? I'm hoping it's just a setting that needs changing?

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    01-03-2015
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Pasting from google sheets into excel skips empty cells and "" results

    Ahhhhhhhhhhhhh, and a further problem of the hopefully the same type

    One of the questions on the google form is for a full address, and if clients use ENTER to put their address on several lines, though this data is in one cell in google sheets, it is entered onto several cells in excel

    hence i think the problem is that excel isn't pasting 'cells', but it's as if the data is being converted to txt format and then enter in tab delineated... or something like that...?
    Is this happening to anyone else?
    Help!

+ 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. Excel equivalent to Google Sheets' "importdata" function?
    By bgreeson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2017, 11:46 PM
  2. equivalent of Google Sheets "Split" function in Excel
    By reynastus2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2016, 04:14 PM
  3. Replies: 2
    Last Post: 02-28-2014, 10:15 PM
  4. [SOLVED] Pasting values between ranges in different workbooks: "Range" works but "Cells" doesn't
    By Flaubert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2013, 01:19 PM
  5. Change "Parent" cell based on results of multiple "Children" cells
    By ccowman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2012, 02:33 AM
  6. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  7. Replies: 0
    Last Post: 08-10-2005, 12:05 PM

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