Google Sheets: How do I include a newline within a field in a local .tsv file I want to import

user_11861083 0
Viewed 547

I know that in Google Sheets I can type Control-Return to create a sort of "phantom" return that starts a new line within a field. But what is the actual character that represents this? Obviously it's not ASCII code 13, as that is the record separator.

I would like to be able to include this mystery character in a local .tsv file which I import into Google sheets, so that these multi-line fields will display as such. Is this possible?

Thanks!

google-sheets
1 Answers

it's CHAR(34)

so something like the following in a cell would give two distinct lines of text...

="direct text input"&A3&" more text"&CHAR(34)&"Newline with new text"
user_110751290
Related