The CONCATENATE is a function with which you can combine multiple numbers of data into a single cell. To be exact, you can add 255 items into a single cell with the help of the CONCATENATE function.