I'm using ImportHTML to pull in data scraped using another tool called Import.io, as you can see in the example spreadsheet here. However, when I pull in data using ImportHTML, it's pulling three years of data into one cell, so one cell contains the column heading and three years of financial data.

I want to break out the three numbers in each cell so that there is only one number per cell, but can't seem to figure it out. I've tried splitting the data, trimming it then splitting it, converting using =Value(), but can't get the data into its own cell.

1 Answer 1


Line breaks inside a Google Sheets cell are encoded as CHAR(10). (The function CHAR returns the character with specified numeric code, and 10 is used to represent new line control character.) So, you should use


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.