ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   txt2xls (https://www.excelbanter.com/excel-programming/316789-txt2xls.html)

Thomas

txt2xls
 
Hi,

who can tell me where I can find a (inline command) tool which converts a
*.txt file to a *.xls file?

Regards + TIA

Thomas



sujata_ghosh[_7_]

txt2xls
 

first of all its good if you tell us what kind of data are in your text
file. and in which form you want to convert it to excel, i mean to say
in column or in row format!

any way you can try in excel

data get external data import text file then chose your txt file and
follow the instruction to break each word or line, with delimter.


sujata.


--
sujata_ghosh
------------------------------------------------------------------------
sujata_ghosh's Profile: http://www.excelforum.com/member.php...o&userid=16432
View this thread: http://www.excelforum.com/showthread...hreadid=278218


Thomas

txt2xls
 
Sujata, thanks!

The txt files are ready to be opened in Excel in column format by users and
that does work.

However the conversion has to be done by a Win app so I need something like
a command line tool which can be called by the app and then saves a xls file
on a HDD.

Regards + TIA

Thomas


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com