Troubleshooting Line Break Errors Caused by Ctrl+Enter in Google Sheets
In Google Sheets, Ctrl+Enter adds line breaks, causing formulas like LEFT and SPLIT to misbehave with multi-line text.
SUBSTITUTE
In Google Sheets, Ctrl+Enter adds line breaks, causing formulas like LEFT and SPLIT to misbehave with multi-line text.