Select delimiter in .txt creation
 

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.

Select delimiter in .txt creation
 

Chip Pearson has written code that allows you to write a text file (csv
style) and specify the delimiter.

http://www.cpearson.com/excel/imptext.htm

--
Regards,
Tom Ogilvy


"Chartsmalm" wrote in message
...
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.

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.