Forum Discussion
Solved
How to split text to columns from newline?
I have cells that contain a newline in middle, as in the cell contents is:
“Text1
Text2”
I want to split it to: “Text1” and “Text2”
Text to columns tool does not seem to have an option to split by newline/linebreak.
Is there an another way to do it?
- I read your question again.
If you want to use the "Text to columns tool" you can insert a linebreak with Ctrl+J (in "other delimiter" or whatever it's called in your version).
CHAR(10)
=TEXTSPLIT(A1,CHAR(10))
- Thanks, that works.
- I read your question again.
If you want to use the "Text to columns tool" you can insert a linebreak with Ctrl+J (in "other delimiter" or whatever it's called in your version).This solution does not work for Excel 365 for Mac, nor on Excel 365.
What other workaround?
