ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I copy data from main frame computer and keep data in cell (https://www.excelbanter.com/excel-worksheet-functions/90943-how-do-i-copy-data-main-frame-computer-keep-data-cell.html)

Doug

How do I copy data from main frame computer and keep data in cell
 
I am trying to copy data from a main frame computer and put on excel
spreadsheet. How do I do this and keep basic format? There are 3 line item
per screen and about 15 screens.

Bernard Liengme

How do I copy data from main frame computer and keep data in cell
 
Same the data from mainfram as a text (ASCII) file and transfer to PC; Open
with Excel and use Data |Text to Columns to separate items.
Better yet, if main frame allows,: save data in a comma delimited file -
commas between each item. Excel will open this and recognize the fields if
you call it something like Mydata.CSV
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Doug" wrote in message
...
I am trying to copy data from a main frame computer and put on excel
spreadsheet. How do I do this and keep basic format? There are 3 line
item
per screen and about 15 screens.





All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com