How can you join some data in a spreadsheet? Through a function called "concatenate", which simply means to join. For instance: IMG_3447 If you wanted to create a single cell with First Name and Last Name it can be done by creating a new column and in first cell where you want to display joined name, type: =A5&" "&B5 which will then add the contents of cell A5, then insert a space, and then add the contents of cell B5 = Lily Pond.