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


enter the image description here