What Excel function concatenates text from one cell into another within the same cell?

• A. Copy Area
• B. Concatenate
• C. Delimiter
• D. Chart

Answer: (B)

Joining text from multiple cells into a single cell uses a text-concatenation function in Excel. The function named Concatenate takes several pieces of text or cell references and merges them into one string, so you can build something like =CONCATENATE(A1, " ", B1) to put a space between the values. In newer Excel versions, CONCAT serves the same purpose and can handle ranges, while TEXTJOIN lets you specify a delimiter and optionally ignore empty cells. The other options don’t perform this operation: Copy Area is used for duplicating data, Delimiter is just the separator character used by some join operations rather than a function, and Chart is for creating graphs, not text manipulation.