Merging Text With CONCAT
Join cells together into one string using CONCAT.
Why Join Text at All?
Spreadsheets often store related text in separate cells: a first name in one column, a last name in another. To show them together as one value, you join (or concatenate) the text.
Joining text lets you build full names, addresses, product codes, or email subjects without retyping anything. When the source cells change, the joined result updates automatically.
In this lesson you will use the CONCAT function to merge text from several cells into a single string.
Meet the CONCAT Function
CONCAT takes one or more pieces of text and sticks them together in the order you list them.
The basic shape is =CONCAT(text1, text2, ...). Each argument can be a cell reference like A2, a typed string in quotes like "Hello", or even a range.
It returns everything as one combined string. Below, A2 holds Ada and B2 holds Lovelace.
=CONCAT(A2, B2)