Combine texts together/’&’, CONCATENATE To combine words/texts, we use the following formula, function. =text1 & text2 & [text3]… [text1] = Identify 1st word to combine. [text2] = Identify 2nd word to combine. Definition of formula A formula to combine specified words. EXCEL version Excel2003 ・ Excel2007 ・ Excel2010 ・ Excel2013・ Excel2016 =CONCATENATE(text1, text2, [text3]…) [text1]・・・