Use the CONCAT function (or the CONCATENATE function if you are using Excel 2013 or earlier) to create the "Transaction Statement" in cell K18. The statement in cell K18 should read "I spent $24.06 at merchant #4931 on: 8/1". To make this statement, combine "Statement P1" in cell D13, the "Amount" in cell D18, "Statement P2" in cell D14, the "Merchant ID" in cell C18, "Statement P3" in cell D15, and the "Date" in cell J18. Copy and paste your function down to complete the "Transaction Statement" column of the table.

Then try StudyFetch, the AI-powered platform that can answer your questions and teach you more about it!