Formulas not working with imoprted data from google sheets

Hi All,

has their been any recent changes with Excel or Google Sheets.

I use to import data into Excel by importing csv from a google sheet file but now when I do this the data is imported and array formulas will not work with the imported data.

Have I missed something

Thanks

Dan

Hi Dan:

Might be a combination of text/numbers that are acting up with the extracted values. TRIM might help too.
Could you post a small sample of the data that "will not work", with the expected results in a sanitized workbook?


Pete