How to put all the cell values in one row

Help
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!

4

this did it for me :slight_smile: thank you