Quote Originally Posted by .paul. View Post
the problem is that you're saving your listview contents as excel CSV + the delimiter in a csv file is a comma.

therefore excel sees that 1 field as several. use a semi colon ; instead of a comma:

vb Code:
  1. Dim lvi As New ListViewItem(xml.SelectSingleNode("Title/LocalTitle").InnerText)

  2. lvi.SubItems.Add(String.Join("; ", Array.ConvertAll(xml.SelectNodes("Title/Genres/Genre").Cast(Of XmlNode).ToArray, Function(n) n.InnerText)))
Thanks. Works. Much appreciated.