Excel issue while writing record in it

try below
str.replace(vbLF & " "," ").Replace(" " & vbLF," ")

Still we are facing the same problem

above should work fine for you…
I tried with your given excel file…
steps I followed is
read excel file into dt
write dt to csv file (semicolon delimited)
read csv as text file into String variable str
str = str.replace(vbLF & " "," ").Replace(" " & vbLF," ")
write text file with variable str

1 Like

how to save recordig data in excel