Example of using the CONCATENATE function in a spreadsheet to combine text from multiple cells.
A screenshot of a spreadsheet in a program like Microsoft Excel or LibreOffice Calc, showing a formula in cell E2 that uses CONCATENATE to merge the contents of cells B2, C2, D2, and A2, resulting in "Hazlitt, Teena". The spreadsheet includes columns for First Name, Last Name, Comma, Space, and Merge Result, with data entries for several individuals.