Split Columns with "," as separator

[AhmedBasheer_M]

Hi, The output of my excel contains one column with all the fieldname in a single row with "," as separator like "Firstname,Lastname,Age,Profession". and this is inside one cellbox. Kindly advise how can I split the field to separate columns using either MS Excel VBO or Collection Manipulation. Thanks Ahmed B

[John__Carter]

Sounds like you are opening a CSV file in Excel. You could try reading the file directly with Utility - Strings.Get CSV As Collection