title: Convert Ascii into Text in Excel
body: <p>I have a file which has a structure as shown in the picture: 
  <a href="https://i.stack.imgur.com/xFCZs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xFCZs.png" alt="enter image description here"></a></p>
  
  <p>I now have the problem that I need to have this data structured in an excel file which eventually should look like in the picture below: </p>
  
  <p><a href="https://i.stack.imgur.com/v8Y6w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v8Y6w.png" alt="enter image description here"></a></p>
  
  <p>I know that each file is in ASCII format and all the fields have a set length. For example from the first picture i know that the start position is 1 and the length is 2 and the field is record type. (as displayed in excel picture. Another example would be that I know that the field record counter starts at character position 34 and has a length of 10. </p>
  
  <p>I am trying a way to "decode" the first picture into excel. 
  Can anyone suggest a way of how to do this in excel or any other way. </p>
  
  <p>Here is the picture of the fields and field length: 
  <a href="https://i.stack.imgur.com/U6Gcz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U6Gcz.png" alt="enter image description here"></a></p>
  
  <p>Thank you in advance </p>