Converting excel file to tab delimited (txt) file

G

Guest

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.
 
G

Guest

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
CSV Tab Delimited 4
Converting Numbers from Excel to TXT files 2
Importing a space-delimited txt. file right-justified into Excel 2
Converting Excel file to text delimited file 3
Keeping Column Formatting When Converting to TXT 1
Generate a TAB When Converting From Excel to Delimited Text 1
Double quotes when exporting to tab delimited file 2

Top