What is the function to merge text data from cell A into cell B, similar to Mail Merge.
Example
Cell A =<Name>
dog
deer
Cell B
Here comes a <nameA1>. The <nameA1> is a big <nameA1> with lots of friends.
The <nameA2> is running. The <nameA2> runs vary fast.
Cell C
Here comes a dog. The dog is a big dog with lots of friends.
The Deer is running. The deer runs vary fast.
I want to be able to inset A cell values into B Cell text at assigned places like the example above. I don't know what this function would be called or how to do it. But, I want to be able to change whats in cell A and it will update cell B. automatically where i insert the variables. And it will/may also give me the ability to insert a variable into a paragraph text instead of typing it out every time.
Any ideas?
Bookmarks