Merge contents of cell A into cell B using a Varialbe

[manoi]

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?

[Mallycat]

You can concatenate cell values like this.

Please Login or Register  to view this content.

[manoi]

Thank you for the lingo "concatenate".

I do not believes this solves my issues. I have a list of 300 items. A1 to A300 = product names. B1-B300 = product descriptions. I want to go be able to add a variable in the description in cell b that will populate what is in the corresponding A Cell. Much like as in a simple excel formula if you type in Cell B1 "=A1" the contents of A1 would automatically appear. A possible solution might be:

Here comes =A1. The =A1 is a big = A1 with lots of friends. Which when exiting the cell should read "Here comes a dog. The dog is a big dog with lots of friends." if I change A1 to "cat" it cell b1 will read "Here comes a cat. The cat is a big cat with lots of friends."

But, to take this one step further, to make a "variable" that equals the content that is in the A column. So what ever is in the A# will populate in the B# cell, and when variable is used exiting the cell reads as it should. The idea being to just inset the variable =<name> for example (like a mail merge), and then when I exit the cell, the product name will appear in those positions.

Therefore I can just inset <name> where i choose. No typing, simply paste <name> where you want it, no possibility for typing mistakes. Like a mail merge just that <name> is what ever is in the corresponding numbers cell.

??

[manoi]

Can anyone answer this one???

[Søren Larsen]

I would like to see a sample of your workbook before being sure how to answer this, but I think that a solution could be some kind of application of =SUBSTITUTE().

[Cutter]

I would say SUBSTITUTE() is the way to go.

In C2 you would have: =SUBSTITUTE(B2,"<name>",A2)