expand ranges

  1. J

    How can I auto expand a list of UK postcode ranges for clean lookup

    Hi there - I hope someone can help. I have a very limited knowledge of VB with an intermediate knowledge of formulas and am using Excel 2011 for Mac. I wish to create a spreadsheet that will enable me to lookup which electricity distribution network companies operate in specific regions in the...
  2. R

    formula to expand ranges

    I have several entries in a column of data... example: t334.1 - t356.9 b044 - b059.7 w120.88 - w129.55 1036 - 1048 1044 2233 239 19 12567 H0876 I'd like to know if it's possible to "expand" these "ranges" to include the lines not shown (and represented by) the "-"... example 2: same list...
    • rmh000
    • Thread
    • data ranges excel expand ranges ranges sequences
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top