Create a CSV file where the content of the "visual" cell is actually in the 1 physical cel

[bobk544]

Hello, i have an Excel file where lists have been created within a cell, but when i create a CSV file, those lists become individual records on their own, so just wondering how i can get all of the "visual" content of a cell to be placed in 1 cell when creating a CSV file?

For example, when looking at the Excel version, you can see:
1=a
2=b
3=c
like a list within a cell, but when i go to create a CSV version of the XLS, i literally get a CSV row for each item of a list ie:
1=a
2=b
3=c

thanks for any pointers!

[bobk544]

Ok got it, thanks anyway!

Sub ReplaceVBLF()

For c = 1 To 1
For i = 1 To 60

For j = 1 To 21

cellval = Worksheets(c).Cells(i, j)
Worksheets(c).Cells(i, j) = Replace(cellval, vbLf, "")

Next j

Next i
Next c

End
End Sub