ArrayJoin formula doesn't deliver requested separator

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 ?

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

worked like a charm ! Thank you !!!