View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mov1904@gmail.com is offline
external usenet poster
 
Posts: 1
Default Export from Excel using alternative delimiters

Hi all,

I need to export from Excel a large table in text format, and I cannot
use
either tab or comma.
I am aware of these solutions:
1- http://www.cpearson.com/excel/imptext.htm#Export (which kind-of-
works
but has a problem with size);
2- changes in regional settings (problem with impact on other lists,
etc.)

Preferably I would like to use a column delimiter ALT-028 and a row
delimiter ALT-030 (both invisible and cannot be typed).
Is there a solution to this problem?

I do not use Excel often and I do not know VBA programming, and since
this
is a one time issue, I cannot afford to learn it now.
This is why I am addressing the experts in this group.
I believe my problem should be common enough to have been solved by
now.
"There is no solution to this problem" is also an acceptable answer, I
just
need to know.

Many thanks in advance,
- Mike Ov.