How to split text by newline code "/n"?

Hi @chenghai0208,

Use anyone of them as a delimeter

vbCrLf - when you have both carriage return(Cr) and Line feed(Lf) in the string
vbCr - Only when Carriage return(Cr) in the string
vbLf - Only when Line feed(Lf) in the string

Reference : vb Constants

8 Likes