title: excel function to combine cells into single line of text?
body: <p>I'm new to stack overflow so I apologize if this is a horrendously stupid question. I am wondering if there is a function or way to code a function in excel that will combine a column of cells with plain text and convert them into one cell with the text on a single line? Specifically I want to convert a column of random numbers into a single line of text and insert SPACE+AND+SPACE between them.</p>
  
  <p>Ex. </p>
  
  <p>15133484</p>
  
  <p>12345188</p>
  
  <p>12345888</p>
  
  <p>to</p>
  
  <p>15133484 AND 12345188 AND 12345888</p>
  
  <p>Currently I am copying and pasting all this information into google and then into Word and using find/replace and it is taking forever everytime. If it is possible to just get Excel to do this for me that would be amazing. </p>
  
  <p>Thanks!</p>