Concatenate allows you to string together cells. You can use this function to put together customer names if the first and last names are located in separate cells or combine cities and states organized in different columns. The basic formula for concatenating is: