title: remove alt+enter in excel while generating values
body: <p>I am having an end of line problem, can you guys tell me how to fix it? When I enter a value in excel and then do <kbd>Alt</kbd>+<kbd>Enter</kbd> then the values in that cell breaks and moves to next line. I wanted to make it in single line. Not sure how to do it.</p>
  
  <p>For example right now I am getting output like this:</p>
  
  <pre><code>EnvName=testing  testing 
  testing testing`
  </code></pre>
  
  <p>but the generated output should be like this:</p>
  
  <pre><code>EnvName=testing  testing testing testing
  </code></pre>
  
  <p>Providing my code below</p>
  
  <pre><code>Sub export()
    Dim i As Long
  
  
              Value = Sheets(Itm).Cells(i, 4).Value
              'If InStr(1, Sheets(Itm).Cells(i, 4).Value, " ") Then
              '  Value = """" &amp; Sheets(Itm).Cells(i, 4).Value &amp; """"
              'End If
  
    Close 1
  End Sub
  </code></pre>