Replacing a text variable with a list of keywords

[rc5781]

I was wondering if anyone could tell me how to do the following:

Let's say I have a phrase such as "I like eating $$$$$."

How can I automatically replace the $$$$$ (a text variable) with a list of words such as "burgers", "hot dogs", "pizza" so the result would be the following in different cells?

I like eating burgers.
I like eating hot dogs.
I like eating pizza.

Thanks in advance...

 

[NBVC]

I assume that you will have a separate table of words to substitute.

Then simply substitute the $ with the match item in the corresponding side table.

Formula in B1: =SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1," ","#",2))),F1)

where F1 contains the first substituting word.

Then copied down.

Note: If your phrase is not "I Like $$$", then replace the number 2 in the Substitute function, with the number of spaces between words in your phrase.

AddToFormulas.xls
	A	B	C	D	E	F
1	I like $$$	I like burgers				burgers
2	I like $$$$$	I like fries				fries
3	I like $$	I like pizza				pizza
Sheet3

Does this work for you.?