Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All, I have a text file that contains 17 lines of header
information and then a bunch of data from rows 18 on. I need to import the data to remove one column and the re-export the data as a text file, I can do all of this manually but I wanted to try and automate the process as it takes up way to much of my time to do this everyday with all the data. Here is my ultimate goal: 1-Import the text file and save the header information to attach to the text document that is exported. 2- Delete column E after importing the raw data starting at row 18 3-Put the header information back on top of the data and export as a text (tab delimited) file. If anyone wants I can email the text file it is too big to post here. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import / export data | New Users to Excel | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import/Export | Excel Discussion (Misc queries) | |||
import/export data from a workbook | Excel Discussion (Misc queries) | |||
data import and export in to access | Excel Discussion (Misc queries) |