vba - remove alt+enter in excel while generating values -

i having end of line problem, can guys tell me how fix it? when enter value in excel , alt+enter values in cell breaks , moves next line. wanted make in single line. not sure how it.

for example right getting output this:

envname=testing  testing  testing testing` 

but generated output should this:

envname=testing  testing testing testing 

providing code below

sub export()   dim long               value = sheets(itm).cells(i, 4).value             'if instr(1, sheets(itm).cells(i, 4).value, " ")             '  value = """" & sheets(itm).cells(i, 4).value & """"             'end if    close 1 end sub 

whenever pick value cell on sheet, if might have line break in need replace it, avoid getting same line break in output:

value = replace(sheets(itm).cells(i, 4).value, vblf, "") 

not sure you'd want replace line break with: here i've used empty string can use else.