Converting excel file to tab delimited (txt) file

K

Kusuma

is it possible to convert excel file to tab delimited (txt) file with certain
space or character numbering?

for example: Column A consist 5-10 characters in each row. When saving the
excel file using tab delimiter. I want all values on column B start in line
15.
 
M

Martin Fishlock

Using the standard excel saveas command it is not possible to do as requested.

But the solution is to replicate the sheet on another sheet with the
formatting,

ie:

[A3]=LEFT(A1,14)&CHAR(9)&REPT(" ",15-LEN(A1))&B1

and then copy and paste special and delete the columns a and b.

the char(9) inserts a tab and then you save as a tab delimited file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tab delimited characters 1
Converting Numbers from Excel to TXT files 1
CSV Tab Delimited 4
Double quotes when exporting to tab delimited file 2
Saving as tab delimited or comma delimited 0
Converting excel 2007 to tab delimeter text file 1
Importing a space-delimited txt. file right-justified into Excel 2
Saving as txt file 2

Top