
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2019 03:06 PM
To any formula ninjas,
A column has multiple keywords/values. I need to add a pre-fix before each of the values.
From:
column: Colour
values: White, Black, Blue
To: add the prefix “Colour_” to each one of the values in the colour
values: Colour_White, Colour_Black, Colour_Blue
I created another column with the prefix Colour_, and then a basic concat, but the result is (of course):
Colour_White, Black, Blue
I don’t know how to add the prefix to each of the values individually, and if concat is the right formula.
Detail: not all columns will have a value, so need to consider an empty cell.
If anyone has a good idea… much appreciate it !
Christie
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2019 03:18 PM
Like this?
If so, here’s the formula:
IF(Colours, "Colour_" & SUBSTITUTE(Colours & "", ", ", ", Colour_"))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2019 03:18 PM
Like this?
If so, here’s the formula:
IF(Colours, "Colour_" & SUBSTITUTE(Colours & "", ", ", ", Colour_"))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2019 03:20 PM
You clever devil - that’s it. :nerd_face:
Thank you very much !!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 03, 2024 05:41 AM
how can I modify the formula to append a suffix instead of a prefix?
