title: Excel: Match the value in a row and replace value
body: <p>Is it possible to select multiple rows that match a certain value and the replace the matched row values? </p>
  
  <p>I have 25000 rows to work of.</p>
  
  <p>For example, there are <code>gender</code> column. The original value is <strong>1</strong> for <strong>male</strong> and <strong>2</strong> for <strong>female</strong>. </p>
  
  <p>Now I want to change the value <strong>"1"</strong> to <strong>"male"</strong> and value <strong>"2"</strong> to <strong>"female"</strong>. </p>
  
  <p>Are there any other way to do this without going one by one? </p>
  
  <p>Thank you</p>