How to split up a row of a specific excel column by "new line"?

[hailey7 (Hailey)]

Thanks Manjula!

i’ve done this and it works.

Also, referred to this for additional reference (if it helps anyone else in the future too)

Use of Substring in Level 3 Assignment 2

Can anyone explain the components of this in bold? I don’t know .NET but I do understand splitting a string using a CRLF as a delimiter. I’ve done simple operations with substring, successfully experimenting but not with the .ToCharArray method. Also the general structure of the statement with the “0” index I do not understand. VendorInformation.Split(Environment.NewLine.ToCharArray)(0).Substring("TaxID: ".Length)