Skip to main content

Hello 👋t3:


I get concatenated values from a roll-up.

The result is: CotisationsONIRCP

I want this: Cotisations ONI RCP (with black in between each value)


I tried using this formula but it does not change anything:

CONCATENATE(values)&SUBSTITUTE(“”," ")


Any advice?

Thanks!

Hi Elodie, try using ARRAYJOIN(values, " ") instead



Reply