
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2022 05:46 AM
Hello :wave: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!
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2022 05:52 AM
Hi Elodie, try using ARRAYJOIN(values, " ")
instead
Reply
1 Reply 1
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 03, 2022 05:52 AM
Reply
