title: MS Excel : How to divide income range into groups?
body: <p>I am having a table that has 2500 rows. </p>
  
  <p>There is a column <code>Income</code> which has the values in the form of ranges.</p>
  
  <pre><code>10000 - 14999
  100000 - 149999
  15000 - 19999
  150000 - 174999
  175000 - 199999
  20000 - 24999
  200000 - 249999
  25000 - 29999
  250000+
  30000 - 34999
  35000 - 39999
  40000 - 44999
  45000 - 49999
  50000 - 54999
  55000 - 59999
  60000 - 64999
  65000 - 74999
  75000 - 99999
  Under 10000
  </code></pre>
  
  <p>Some are blank cells.</p>
  
  <p>I need to create a new column based on this </p>
  
  <pre><code>1.$ 30000- $50000- Low Income Group
  2.$ 51000-$125,000-Medium Income Group
  3.$ 125,00-$ 250,000-Higher Medium Income Group
  4.$ 251,000- $ 500,000-Donor Group
  5.$ 500,000 and Over- Bigger Donor Group
  </code></pre>
  
  <p>I am not good at Excel, can someone please guide me through? </p>
  
  <p>It would be appreciated, I am using Excel 2010</p>