title: Extract number between brackets in Excel?
body: <p>I've been searching up and down for an answer to this, but haven't found anything I can get to work. It may well be my lack of knowledge in the more "codey" aspects of Excel.</p>
  
  <p>Anyway, this is my situation:
  In C2-C17, I have some text set up like this:[2] Name of job.
  The "[2]" indicates the hours we expect the assignment to take, the rest is the name of the assignment.</p>
  
  <p>Now I need to calculate how many hours all this adds up to, so in B2-B17 (the numbers will change) I would like to extract the number between the brackets, in this case "2", so I can simply calculate and add them up.</p>
  
  <p>How would I go about doing this? I've spent far too long at work by now, trying to find a solution that works for me.</p>
  
  <p>Any help would be very much appreciated!</p>