• How about using the replace() function when selecting the data to export? Here is an example.

    declare @test-2 varchar(8000)

    select @test-2 = 'test

    test

    test'

    select @test-2

    select replace(replace(@Test, char(10), ''), char(13), ' - ')