Excel does not have an export format that would remove the line breaks from the data. You could, however, produce such an output using a Directory mailmerge in Word. To do this:
1. Start Word and go to Mailings
2. Choose Start Mailmerge>Directory
3. Choose Select Recipients>Use existing List, then navigate to and select your workbook.
4. Choose Insert Mergefield and click on each of the items, in turn
5. Press Alt-F9 to reveal the mergefield coding, it should look like:
{ MERGEFIELD "_WGOP_samp_inpu_2" }{ MERGEFIELD "F2" }{ MERGEFIELD "F3" }{ MERGEFIELD "F4" }{ MERGEFIELD "F5" }{ MERGEFIELD "F6" }
6. Edit each of these fields by inserting \f "→", where the → is a TAB character, so they all end up as:
{ MERGEFIELD "_WGOP_samp_inpu_2" \f "→"}{ MERGEFIELD "F2" \f "→"}{ MERGEFIELD "F3" \f "→"}{ MERGEFIELD "F4" \f "→"}{ MERGEFIELD "F5" \f "→"}{ MERGEFIELD "F6" \f "→"}
7. Choose Finish & Merge>Edit Individual Documents>OK
8. The output can now be saved as a text file from Word.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]