title: Obtain primary name from list of aliases in Excel
body: <p>I have a table of names with aliases divided into rows. 
  <a href="https://i.stack.imgur.com/YKpLt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YKpLt.png" alt="enter image description here"></a></p>
  
  <p>I'm trying to obtain the clean name, in this example "Peter Parker". No matter if I search for "Operator PETER.PARKER" or "Operator Peter Parker", the function above only looks for the keyword in the first column, not in column 2 or 3.</p>
  
  <p>I've searched for a native way in excel to deal with aliases, but either there is none, or I don't know where to look. </p>
  
  <p>If possible I'd like to keep it simple (no vba).</p>
  
  <p>Thanks in advance!</p>