ArrayJoin formula doesn't deliver requested separator

[Alex_Liberchuk]

I have Lookup Field (“Status”) that has many records with multiple values per cell. I want to parse out these values using ARRAYJOIN(Status," | "). It only returns me the comma-separated values , without “|”.

Any thoughts ?

[kuovonne]

Use your formula in a rollup field based on the same linked record and referenced field as the lookup.

[Alex_Liberchuk]

worked like a charm ! Thank you !!!