text: user15767: I'm trying to find if the peptides in column A are present within the longer peptides of column B.
  Pairwise alignment tools take the data from both columns as one string (i.e., TIIDYTNNHYTNNHLEII... and PFYMNITGYTDAYNTDIIDYIIDYTNNHLEIITLFN...) which leads to a number of peptides from column A left unaligned even though the peptide is present within one of the longer peptides in column B.
  I would like to find a method that works for detecting such peptides.
  
  
  user2108: I don't think that you want an alignment so much as you want to test for the presence of an exact substring (column A) within larger strings (column B).
  There are simple excel utilities that do this, for example the SEARCH() function. There is no need to use alignments.
  
original_text: 15767: <p>I'm trying to find if the peptides in column A are present within the longer peptides of column B.</p>
  <p>Pairwise alignment tools take the data from both columns as one string (i.e., TIIDYTNNHYTNNHLEII... and PFYMNITGYTDAYNTDIIDYIIDYTNNHLEIITLFN...) which leads to a number of peptides from column A left unaligned even though the peptide is present within one of the longer peptides in column B.</p>
  <p>I would like to find a method that works for detecting such peptides.</p>
  <p><a href="https://i.stack.imgur.com/i621I.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/i621I.jpg" alt="columns depicted here" /></a></p>
   2108: <p>I don't think that you want an <em>alignment</em> so much as you want to <em>test for the presence of an exact substring</em> (column A) <em>within larger strings</em> (column B).</p>
  <p>There are simple excel utilities that do this, for example the <code>SEARCH()</code> <a href="https://exceljet.net/formula/cell-contains-specific-text" rel="nofollow noreferrer">function</a>. There is no need to use alignments.</p>
  