title: Excel: =SWITCH() not working with wildcard character *
body: <p>I have one column that contains age, gender, weight. (I get the spreadsheet from an outside source, and there is no way to get the data in a different format)</p>
  
  <p><code>9 - 10 Male 60.1 - 67lbs</code></p>
  
  <p>I made a formula in a new column to pull out the gender with switch and the wild card character.</p>
  
  <p><code>=SWITCH(A2, "*Male*", "Male", "*Female*", "Female", "ERROR")</code></p>
  
  <p>However, having the wildcard character there does not work, it breaks the formula. Is this a restriction on the switch statement or is my syntax wrong?</p>
  
  <p>I need to also pull out the age and weight, an example of ages I would look for: 8-9, 10-11, 12-14, etc. I was thinking this formula with the wild card character would work, but I guess not. Is there a different way I should be doing this?</p>