Can't figure out your email address, so here goes.

This is how I would do it.
Import into Access:
select file type "text" files.
Pick option "fixed length".

Then you can export it to an excel workbook from Access.

There's actually a way to do it in Excel:

Let us say all your data is in column A.
Enter this in B1:
=Mid(A1,1,4)
(assuming the first data block is 4 characters, starting with the first character)
C1:
=Mid(A1,5,8)
(assuming next column's data starts with the 5th character and is 8 characters long).
And so on...
You can click on B1 and grab the little black square in the lower right-hand corner of B1, drag it down  to the bottom of the spreadsheet. This will dupilcate the formula correctly.

Anyway, if you send me a speadsheet with column A populated, I can do it for you.

Finn

Russell Duffy wrote:

Greetings,

 

This is only distantly related, since it might be a way to collect data from the EM2, but for now it's for my Dynon.  I'm looking for someone who knows a lot more about excel than I do.  I have managed to collect raw serial data from the Dynon, which is a string of about 120 ASCII characters per line.  I need to be able to import this into Excel, but have it spread out across multiple columns. 

 

For example, I might want the first two characters of each line in the first column, then the next four characters in the 2nd column, etc, defining how many characters go in each column.  If there were delimiters in the data, it would be easy, but there aren't any.  

 

If anyone can help me figure out how to do this, please email me offlist.  I really don't want to clutter the list with this.  

 

Thanks,

Rusty 

russell dot duffy at gmail dot com