title: Single Line to Double-line Formatting in Excel
body: <p>In my job I have to enter warranty information so that POs can be cut. Vendors are very particular with how this is entered and each one has their own format. </p>
  
  <p>One of them requires data be entered:</p>
  
  <blockquote>SN:<br>
  MACHTYPE:</blockquote>
  
  <p>Further, the information for this is sent in a single composite number, something like:</p>
  
  <blockquote>10Y754235FUYJ9</blockquote>
  
  <p>Requiring the final input of data to be:</p>
  
  <blockquote>SN:10Y75423<br>
  MACHTYPE:UYJ9</blockquote>
  
  <p>The first 4 digits of the composite are the MACHTYPE and the final 8 are the Serial Number.</p>
  
  <p>The impasse I've reached is I can't seem to get auto-fill to replicate the skipping of lines as I've formatted. It will jump a number of lines equal to however many I've selected.</p>
  
  <p><a href="https://i.stack.imgur.com/uoFoV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uoFoV.png" alt="enter image description here"></a></p>
  
  <p>Any ideas about getting it to replicate the first four Formatted Data? I've been throwing myself at this for a couple hours now.</p>
  
  <p>Thanks in advance!</p>