I need help with finding why only Line Break is exported in first column Header is exported but not Line Breaks in subsequent Column Headers?
iPad mini 6
Sorry sorry.
Yesterday I tested the transfer with cut and paste. The result is as reported: ¶ puts the content in different rows in (online) Excel, and ↩︎ keeps it in the same cell on separate lines.
However, exporting to an Excel file is different: ¶ keeps the content in the same cell on separate lines (which seems to be the case for your cell F1), and ↩︎ does absolutely nothing, as if it didn't exist (which seems to be the case for your cells G1 and H1).
So you have two choices, depending on the method you want to use to transfer this data to Excel:
Cut and Paste: you use ↩︎ (control-Enter) to split the lines.
Export: you use ¶ (Option-Enter) to split the lines.
Sorry sorry.
Yesterday I tested the transfer with cut and paste. The result is as reported: ¶ puts the content in different rows in (online) Excel, and ↩︎ keeps it in the same cell on separate lines.
However, exporting to an Excel file is different: ¶ keeps the content in the same cell on separate lines (which seems to be the case for your cell F1), and ↩︎ does absolutely nothing, as if it didn't exist (which seems to be the case for your cells G1 and H1).
So you have two choices, depending on the method you want to use to transfer this data to Excel:
Cut and Paste: you use ↩︎ (control-Enter) to split the lines.
Export: you use ¶ (Option-Enter) to split the lines.
There are two ways to put line breaks in a cell. With Control-Enter (character code 8232) and with Option-Enter (character code 10).
Control-Enter in Numbers (same as on iPhone)
Copied and pasted in Excel, content appears all in one cell.
Option-Enter in Numbers
Copied and pasted in Excel, content appears in different cells.
Therefore from your picture, it looks like column F was entered with Control-Enter and the other ones with neither Control-Enter nor Option-Enter. Numbers just continues on the next line because the column is too narrow (see G1 in Excel compared to F1 in Numbers). I don't know how cuts between words or characters are managed differently than with latin characters.
This was tested with Excel online since I don't have a desktop version.
In a CSV file, a linefeed puts data in another row. What you need is a continuation character (8232) entered with Control-Enter (or Insert menu on the iPad).
Edit your Numbers cells G1 and H1 and select their whole text to see what exactly makes the text flow from one line to the other (symbols in blue). Add whatever is necessary to force the linefeeds where you want them to be.
As asked above, is there a reason you can't use 'Wrap Text in Cell'? In Numbers for iOS you see that after tapping the format (paintbrush) icon?
That is my experience by far the safest and easiest approach when exporting to csv or another app involved, 省麻烦！
SG
As with CSV, line breaks within a cell can cause trouble when exporting. Any way you can do without them?
SG
The Line Breaks not exported in subsequent Headers are already character code 8232.
Is there a reason you can't use 'Wrap Text in Cell'? In Numbers for iOS you see that after tapping the format (paintbrush) icon.
Best avoid any kind of line breaks when export is involved.
SG
I need multiple exporting same file ( different versions) to Excel because
①Excel Mobile for 8.3 inches screen size cannot handle co-authoring which would reduce the times of exporting my data to be used by another user
② my other user who is also entering data entry to my file isn’t computer savvy enough to adjust column width of exported but without post-processing for lost line breaks (for most columns).
③ I tried copying whole row from Numbers to Excel after exported.
Would you know of better way?
thanks, I followed following link
https://talk.macpowerusers.com/t/line-break-in-a-cell-in-numbers-for-ios-iphone/16620/2
Just tap when you see the cursor, and you should get the menu with Insert in it. If you’re editing a new cell, your first tap will show the cursor and also the menu.
That is probably the same character as when typing option-return on the Mac.
Is there a reason you can't use 'Wrap Text in Cell'? In Numbers for iOS you see that after tapping the format (paintbrush) icon.
I try to avoid line breaks within cells, especially if I know I will have to export.
SG
Thanks.
if export is not working for line break, I need help with copying row (header having line breaks) from Numbers to Excel. This didn’t work either.
is it due to Excel mistakenly treating Line Feed as cell delineation?
Thanks but with iPhone onscreen keyboard, I need help how to use ¶ (Option-Enter) to split the lines.
BTW, first header $H1 is exported correctly but not subsequent headers such as $G1. Their Line Breaks are identical as shown below
I'm not sure I understand the problem clearly enough to suggest a workaround.
How are you entering the "line breaks"? Option-return?
SG
How to export Line Breaks in Apple Numbers to Microsoft Excel? First Header (containing Line Breaks) works but not subsequent Headers.
