Exporting lists to txt files

  • Thread starter Thread starter Alan Davies
  • Start date Start date
A

Alan Davies

I need to export a list of numbers so that when they are opened in a text
file there will be a semi colon between each number.
I've tried various ways to do this but to no joy - can anyone help

The original list is probably consecutive numbers - in one column - that
then will appear in the text file as for example:
12345; 12346; 12339; 12334;

thanks
 
Alan,

Your numbers are in a column, but you want them written to a text file with
only semicolons (essentially in a row). You do not want line feeds between
each.

If there are 256 or less of them, use Edit - Paste special - Transpose, to
an empty sheet. That will put them in a row. Save that sheet as *txt
(File - Save as, set File Type to *.txt). You'll have to have your Windows
Regional Settings list separator character set to the semicolon (Control
Panel - Regional Settings).

If there are more than 256 of them, and you really do want only semicolons
(no line feed character sequences), Try the Text Write Program at
www.smokeylake.com. Set the record delimiter to Character - ;, and the
field delimiter, well it doesn't matter. If there is stuff in other
columns, you'll have to set Write Entire Sheet to No, and select the column
before running the program.
 
Back
Top