title: Excel: Cell with multiple lines of text into one line of text
body: <p>I have about 4000 cells, each with about 4 separate lines of text. Each line of texts has been entered using the ALT+ENTER method. </p>
  
  <p>Can anybody suggest a way, either VBA or Excel command/method to convert each of of these cells into one line, with spaces between the words.</p>
  
  <p>Example:
  Current
  Cell 1:</p>
  
  <ul>
  <li>About</li>
  <li>Horse</li>
  <li>Dog</li>
  </ul>
  
  <p>Need:
  Cell 1:</p>
  
  <ul>
  <li>About Horse Dog</li>
  </ul>
  
  <p>Any help is much appreciated</p>