View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Exporting to txt file, how to insert a "Enter" between lines

Perhaps I misunderstand: When you save a workbook as .txt, tab delimited,
there is normally an Enter (CR + LF) between each row from the worksheet, so
as long as your worksheet data range is arranged in rows the standard "Save
As" should work, I would think; is there something peculiar about how your
data is arranged on the sheet, or is there something different that you need
in the output .txt file?
--
- K Dales


"fidller" wrote:


Hi
I need to export a spreadsheet to a text file, (tab delimited) for
importing into our accounting program (MYOB).
The accounting program needs an "Enter" between lines to recognize next
customer.
How do I do this from within Excel

I can do it by having a empty cell between each entry, just does not
seem very elegant

Cheers
Kim


--
fidllerPosted from http://www.pcreview.co.uk/ newsgroup access