Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Retaining formats | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel |