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 ...
- 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))
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).
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?- According to the web, there is no equivalent to Ctrl+J for mac
But in Excel 365, you can use the TEXTSPLIT() formula instead:
https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
=TEXTSPLIT(A1,CHAR(10))
or maybe its 13 on a mac?
=TEXTSPLIT(A1,CHAR(13))
- Great way, though a bit unintuitive. Thanks
