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.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Kusuma" wrote:

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.