title: Generate a specific range of IP address in MS.Excel
body: <p>I want to generate a specific range of IP from <code>192.168.1.0</code> to <code>192.168.255.255</code></p>
  
  <p>How can I do that job in Microsoft Excel?</p>
  
  <p>I used these formulas, but not work for all range of IP address:</p>
  
  <pre><code>Excel IP Addresses Increment the Third Octet
  ="10.1."&amp;ROWS($A$1:A1)&amp;".1"
  Excel IP Addresses Increment the Fourth Octet
  ="10.1.1."&amp;ROWS($A$1:A1)
  </code></pre>