concatenate

the joining of two separate words in everyday life or in a spreadsheet formula.

=if(C7=1,0,concatenate C7,C9) where the cell C7 contains a word in the spreadsheet like good and the cell C9 contains a word like morning the result of the formula under certain circumstances would then be good-morning