Concatenate merges the data you have inserted into columns into its own cell or column in Excel. ... I’ve made it bold, centered the text, and increased the font size.