google sheets – How to replace data from one column in one placeholder to another


Step 1: Create 3 column names like City, address, exit from A4 to C4

Step 2: fill in the city and address you want

Step 3: Choose D4 as the desired EXIT sample text with variable Data_City Y Data_Address

Step 4: use Substitute to replace variables

=SUBSTITUTE(SUBSTITUTE($D$3,"Data_City",A5),"Data_Address",B5)

enter the image description here