Data Parsing Error

In Google Sheets, Ctrl+Enter adds line breaks, causing formulas like LEFT and SPLIT to misbehave with multi-line text.