Pasting from google sheets into excel skips empty cells and "" results
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!
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By bgreeson in forum Excel Programming / VBA / Macros
Last Post: 01-25-2017, 11:46 PM
By reynastus2 in forum Excel Formulas & Functions
Last Post: 03-21-2016, 04:14 PM
By Sparkplug90 in forum Excel Formulas & Functions
Last Post: 02-28-2014, 10:15 PM
By Flaubert in forum Excel Programming / VBA / Macros
Last Post: 01-13-2013, 01:19 PM
By ccowman in forum Excel Formulas & Functions
Last Post: 12-14-2012, 02:33 AM
By Suni in forum Excel Charting & Pivots
Last Post: 02-03-2008, 05:11 PM
By Rom in forum Excel General
Last Post: 08-10-2005, 12:05 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1