![Agora_Orbis Agora_Orbis](https://community.airtable.com/legacyfs/online/avatars/3X/0/1/012138ca1ed0b95cc59a18907177decbbd796fb8.png)
- 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
![Justin_Barrett Justin_Barrett](https://community.airtable.com/legacyfs/online/avatars/3X/3/2/322b62e252e04faf5485b361bfe1e5a346583374.png)
- 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_"))
![Justin_Barrett Justin_Barrett](https://community.airtable.com/legacyfs/online/avatars/3X/3/2/322b62e252e04faf5485b361bfe1e5a346583374.png)
- 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_"))
![Agora_Orbis Agora_Orbis](https://community.airtable.com/legacyfs/online/avatars/3X/0/1/012138ca1ed0b95cc59a18907177decbbd796fb8.png)
- 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 !!
![Il_Ballo_del_Do Il_Ballo_del_Do](https://community.airtable.com/legacyfs/online/avatars/2X/4/43120ffc97ce52f2cd9ac925b67bb290c953e9ab.png)
- 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?
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)