'Replace text in Google Sheet depending on the value of another column

Been struggling to find a way to get this done faster, at the moment I am using mailmerg on linux to create multiple versions of the text and manually posting them in my sheet.. Is how could I update lets the message column's placeholder value with column ID's value.

ID Message
3 sample {ID} not avaliable
4 sample {ID} not avaliable


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source