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.