CONCATENATE with prefix for multiple values in the column

[mmr1443]

If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a  prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.

I am doing this so that it will reference a price list. We offer the same products to each company, but each company has a different set of prices. 

I was going to figure out how to automate the copy/paste from PRICE CODE to PRICE, but I couldn't even figure out how to get the price code in the correct format. Thanks in advance for any help!

[TheTimeSavingCo · Accepted solution]

Try using `SUBSTITUTE()` instead:

 

{Company} & " " & 
SUBSTITUTE(
  {Products},
  ", ",
  "," & {Company} & " "
)

[mmr1443]

Ahhh thank you so much! This had me pulling out my hair. Really appreciate it!!! It worked like a charm.

[mmr1443]

I thought I would be able to figure out how to automate the copy/paste from "Price Code" to "Price" column, but I am struggling. Would you have any advice in that regard? Thanks!

[TheTimeSavingCo]

Yeap sure, I've replied to your other post