Converting excel file to tab delimited (txt) file
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. |
Converting excel file to tab delimited (txt) file
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. |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com