| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mainframe file to excel spreadsheet
When I use batch FTP to send a file from the mainframe ( flat file ) to a
server as an .xls file, I get three columns of data in the first cell ( A1 ). I would like to know if there is a way to get each of the three pieces of data per line into three separate cells ? The data looks like this: OPER.DEVE 014 4/24/2007 OPER.PRDD 043 4/24/2007 OPER.PRDJ 052 4/24/2007 Thanks for any suggestions. Dave Cox United Stationers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export EXCEL spreadsheet to .csv file | Excel Discussion (Misc queries) | |||
| How to transfer a mainframe file to excel | Links and Linking in Excel | |||
| How to transfer a mainframe file to excel | Excel Discussion (Misc queries) | |||
| Embedding a file into an Excel spreadsheet? | Excel Worksheet Functions | |||
| Need to save file for mainframe | Excel Discussion (Misc queries) | |||
Threaded Mode
