title: Show only rows that contain a certain text string, in any column
body: <p>My challenge: to <strong>show only the rows that contain a certain text string, no matter which column that text string appears in</strong>, even if the string is surrounded by other text (like finding the "mnd" inside "aac,mnd, jxt". Here's a simple example:</p>
  
  <p>I have a spreadsheet of musicians who signed up to play some songs. Each row is a song. Each column is an instrument (guitar, bass, etc).</p>
  
  <p>They add their initials to a cell. If someone else already signed up before them, they can add a comma and tack on their initials to the end. So, 2 guitarists on a song would look like "aac, mnd".</p>
  
  <p>I need to show only the rows that have "mnd" (for example), so I can see all the songs she signed up for. But the "mnd" might appear in <em>any</em> column. Maybe on some songs, she plays bass, but on others, she plays guitar.</p>
  
  <p>If she signed up later, her initials are tacked on like this: "aac, mnd,joe"</p>
  
  <p>I need to see <em>all</em> rows that have "mnd" <em>anywhere</em>, even if there are commas, spaces, other text.</p>
  
  <p>Is it possible? I'm using Excel or a Google spreadsheet (I don't care which). <strong>I found ways to filter the rows based on <em>a single</em> column, but I need to filter based on a text string that could be in <em>any</em> column.</strong> How?</p>