How to put all the cell values in one row


#1

i have a cell that has its value in two lines
how can i write value in one line?

i would like to use codes to do it rather than using write activity


#2

@Seonyong Removing the carriage return should make it in a single line.

Dim newString As String = origString.Replace(vbCr, "").Replace(vbLf, "")


#3

Thank u so much!