Home |
Search |
Today's Posts |
#1
|
|||
|
|||
import data from a text file
See attached text file. What I am trying to do is to get the data from the 10m sample at each hour, when importing it into excel I find no way to get the 24 samples - one for each whole hour. These are daily files, and I would like to plot the current hour by hour. Untill now I have been scanning the file and entering it into Excel manually, but that gets very boring after a while, anyone can help?? rgds Johnny +-------------------------------------------------------------------+ |Filename: ESCSUM04.txt | |Download: http://www.excelforum.com/attachment.php?postid=3783 | +-------------------------------------------------------------------+ -- jonny365 ------------------------------------------------------------------------ jonny365's Profile: http://www.excelforum.com/member.php...o&userid=27018 View this thread: http://www.excelforum.com/showthread...hreadid=437026 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data using macro | Excel Discussion (Misc queries) | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
problem working with time data imported from text file | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |