Insert new line in string


Hello guys,
Is it possible to insert a new line character in a string?
I found online something like “vbclrf” but that doesn’t work.

I want to concatenate multiple entries from a DataTable, send them to Clipboard and then send them to SAP via the “Copy from Clipboard” option.

Thanks in advance

Paragraph separator

Did you check this?



Either Vbnewline or Environnement.newline should achieve what you want to do.

ex: str = Row1 & vbNewLine & Row2



Indeed, vbnewline did the job, thank you for that.

In case anyone else stumbles upon this thread, another solution that I found for SAP is writing Vertical Line (Ascii 13) and then BackSpace (Ascii 10). Don’t know the logic behind it, but it seemed to work