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