Forum Discussion
Line breaks within a Cell
I have some text (in .txt format) that I wish to enter into a cell. The text contains "new lines" (hex 0A I think) and as a result a copy and paste approach makes the text enter into several cells in a column instead of just one cell. How do I insert all this text into the one cell?
I have tried inserting an <alt><enter> into the text first in place of the strait return but this doesn't do the job.
I am using Excel 2016 for the Mac.
5 Replies
davjam2019 Make sure you switch on Wrap text
for all cells that contain the line feeds (i.e. Alt-Enter or CHAR(10) ).
- All cells in the sheet are formatted to "text" and "wrap".
The text file is created in Apple Notepad.app and the line feeds are type in as <alt><enter>. I have checked the hex code (using another program) and the line feeds are hex 0A decimal 10.
It's not working... 😞davjam2019 On a Mac myself. Don't really know which app you refer to. Can you upload an example of a text file with line feeds and explain how you would want to show it in Excel.
