How to Add Text With a Formula in Google Sheets
Typing text in a Google Sheets cell is simple. But what if you want to edit that text to include more and apply it to multiple cells? Using a couple of different methods, you can add text using a formula.
Source: howtogeek.com