- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 12:02 PM
Hey all! I'm back with a new issue that I'm hoping won't be too hard to solve but I can't seem to find the solution myself. I have two fields that I need to combine. Field 1 contains a variable, such as GKM3, GKM5, etc. Field 2 contains comma-separated values like L16, L17, L18. I have been trying to find a formula to combine the value of Field 1 with each of the values of Field 2. So the output in the 3rd field would be GKM4L17, GKM4L17, GKM4L18.
Unfortunately, when I try a concatenate or substitute function, it only appends the Field 1 value onto the first value in the list, like in Field 3.
I would really appreciate any help!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 07:29 PM
You can also try:
{Field 1} &
SUBSTITUTE(
{Field 2},
', ',
', ' & {Field 1}
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 05:36 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2024 07:29 PM
You can also try:
{Field 1} &
SUBSTITUTE(
{Field 2},
', ',
', ' & {Field 1}
)
