Follow the steps below to append text in Google Sheets using the CONCATENATE function.
Start by opening the Google Sheets document where you want to append text.
Click on an empty cell where you want the appended result to appear.
Type =CONCATENATE(A2, " - Completed") into the formula bar. Replace A1 with the cell reference containing your original text.
Press enter to apply the formula. Your original text and the appended text will now be combined in the new cell.
Follow the steps below to append text in Google Sheets Using & Operator.
Open the Google Sheets where you need to append text.
Choose an empty cell for the output of your appended text.
Type =A2 & " - Completed" into the formula bar, where A1 is the cell with your initial text.
After pressing enter, the cell will display your original text followed by the appended text.
Follow the steps below to append text in Google Sheets using the TEXTJOIN function.
Access the Google Sheets file where you intend to append text.
Click on an empty cell where you want the combined text to show.
Type =TEXTJOIN(" - ", TRUE, A2, "Completed") into the formula bar. Change A1 to your specific cell reference. This formula uses " - " as a delimiter between the original and appended text, TRUE to ignore empty cells, A1 as the original text, and "Completed" as the text to append.
Hit enter to execute the formula. You will see the original and appended texts merged in the cell.
We hope that you now have a better understanding of how to append in Google Sheets. If you enjoyed this article, you might also like our article on how to download images from Google Sheets or our article on how to randomize a list in Google Sheets.
