title: Excel formula to search for text
body: <p>i have a data set of which I wish to analyse.
  I would like to search for the word "head" within multiple cells containing text strings in the same row e.g A2:G2 and then copy the contents of the cell which contains the word "head" into a specific cell destination A1.</p>