replacing a word/variable in one cell with the value in another cell

[jesseka]

I am trying to create a macro to speed up a process I am doing. I want to replace a variable in Cell A2 with the value in cell B2 (and possibly a different variable with cell c2)

Sentence	FirstName	LastName	Output
I am friends with %FirstName%.	John		I am friends with John.
%FirstName% is from the %LastName% Family	John	Smith	John is from the Smith Family

I have been trying to use some macros I have found online, but nothing seems to work.


Thanks in advance for any help.

[arlu1201]

No macros, just some simple formulae...for the 1st one use -

Please Login or Register  to view this content.

For the 2nd one -

Please Login or Register  to view this content.

[jesseka]

Thanks. I forgot to add. the content in column a will vary so I wont be able to use a concatenate function. eg:

%firstname% is my friend and has a last name of %lastname%
%firstname% %lastname% is my friend

etc