View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Select delimiter in .txt creation

Take a look he

http://www.mcgimpsey.com/excel/textf...erentdelimiter

In article ,
"Chartsmalm" wrote:

I need to send an Excel file to a system that expects text with ASCII 124
['|'] as the delimite. Can the delimiter be changed from the tav in excel.
I passing thru Access, where one has control of the delimiter, but Access
made to many changes to the formatting of my data.