Duplicate List & Replace Placeholders

Hi,

I am writing text ads for paid search. There are three columns (headline 1, headline 2, and description). I have attached a sample.

Some of these cells contain text and placeholders. I have a list of brands I want to replace the placeholders with.

Right now I make a copy of all the ads, then manually find + replace with each brand. That's fine for a couple, but now we are talking about 80+ brands.

Looking at the example, I would like to be able to find a way for Excel to take the list of ads, create a second copy, and replace the placeholder [designer] with the list of brand 1, brand 2, and brand 3.

Any ideas would be greatly appreciated.

maybe this one
H2: =SUBSTITUTE(A2,"[designer]",$F2)
drag to the right and down

Sure. The new version is attached. The orange is the before. The green is after. I underlined what is changed between the two. Also, though column B does not show a change, there could be ads where it may have a placeholder as well.

In case it needs clarification, all three cells in a row are part of the same ad.

check this, maybe it will work for you

Formula:

Please Login or Register  to view this content.

adjust references accordingly

see att.

Try

Sheet1 has named range "Brand_List"

in Sheet2

in A2

=IFERROR(SUBSTITUTE(INDEX(Sheet1!A$2:A$100,MOD(ROWS($1:1)-1,COUNTIF(Sheet1!A$2:A$100,"?*"))+1),"[designer]",INDEX(Brand_list,INT((ROWS($1:1)-1)/COUNTIF(Sheet1!A$2:A$100,"?*"))+1)),"")

Copy across and down

Thanks!

That seems to work. Now, I am trying to figure out how to alter the formula to replace additional placeholders. I only had one yesterday when I posted this, but I have since written more and have a total of 3 different placeholders that could be in any given ad.

[designer]
[product]
[gender]

Why did you not post a file with these in the first place?

Post a FINAL file please.

I can say only: LOL

I figured it out.

And I didn't post them in the first place, because they didn't exist. As I mentioned in the previous post, it wasn't until I decided to write more (this morning) that I realized I needed them.

OK: well done.

The additions should follow the same pattern as the "Designer" placeholders.