Concatenate meaning is to join or to combine together. It is useful spreadsheet formula if you need to combine data into one cell. Say for example you had a first and last name, in cells W4796 and X4796 respectively. You would type =CONCATENATE(W4796 , " " , X4796), which would combine the names into one cell, with the " " adding a space in between.