This is a continuation of the discussion at importing text files with newline delimiters (I wish interesting topics wouldn’t be closed just because they’re old).
When pasting data, say, from a web browser into a spreadsheet, you can get an option to select the field separators AKA delimiters. Usually this is commas and tabs, but you can included spaces or any custom character, EXCEPT for line breaks.
This is because line breaks are used to separate records or spreadsheet rows. But it’s kind of an arbitrary restriction. If someone’s messing around with default field delimiters, they probably have an idea what they’re doing.
Work would be so much faster when copying non-table data into a spreadsheet a row at a time, if you could separate each line of data into fields.