title: Excel If/Then to replace text
body: <p>I am somewhat new to Excel, and I am not sure if I need a formula or a macro to accomplish this task. </p>
  
  <p>I need to find all instances of "Jane Smith" and replace it with her employeeID, lets say its 513. </p>
  
  <p>Names only appear in column A, and there may be more than one instance, so I need to search all cells under column A. I need to do this for multiple employees, so I'm guessing it a large <code>If/Then/Else</code>. Thanks!</p>