Please help me to separate returned results in text object

[davyqliks]

I use this

=Concat (Distinct Item_Code)

and get results in a string of text. I require a delimiter to separate the results

i get this

item1item2ite

m3

i require

item1

item2

item3

Thank you in adnvance

[sunny_talwar · Accepted solution]

Try this:

=Concat(Distinct Item_Code, Chr(10))

[davyqliks]

Sunny T strikes again.

Thank you so much Sunny.

[krishnacbe]

or you can use below

=Concat(Distinct Item_Code, '|')