Jun 22 2021 02:59 AM
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.
Jun 22 2021 03:07 AM - edited Jun 22 2021 03:11 AM
@davjam2019 Make sure you switch on Wrap text
for all cells that contain the line feeds (i.e. Alt-Enter or CHAR(10) ).
Jun 22 2021 03:28 AM
Jun 22 2021 03:37 AM
@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.
Jun 22 2021 03:50 AM
Jun 22 2021 06:43 AM
@davjam2019 Sorry! Have no clue what you are talking about.