CONCATENATE

The CONCATENATE function in Google Sheets is a powerful tool to append strings to one another. Whether you're combining first and last names, creating custom descriptions, or manipulating text data, the CONCATENATE function simplifies the task. Dive into our comprehensive guide to master its application.

Parameters

• string1: The first string to concatenate.
• string2, ...: [Optional] Additional strings to concatenate.

Step-by-Step Tutorial

1. Using CONCATENATE with individual strings:

   • Example: =CONCATENATE("Hello", " ", "World")
   • Result: Hello World

2. Using CONCATENATE with cell references:

   • Example: If A1 has the value Hello and B1 has the value World, then =CONCATENATE(A1, " ", B1) will return Hello World.

Working with a Single Value, a List, and a Range

CONCATENATE accepts strings one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =CONCATENATE(A1) — just returns the text in A1.
• List of values: =CONCATENATE(A1, A2, A3) — joins each cell in order with no separator. If A1, A2, and A3 are Hello, " ", and World, the result is Hello World.
• Range: =CONCATENATE(A1:A3) — joins every cell in the range in order, with no separator. Using the same values in A1:A3, the result is Hello World.
• Mixed: =CONCATENATE(A1, " ", B1:B3) — you can combine single cells, literal text, and ranges in one call.

Video Example

Use Cases and Scenarios

1. Name Combination: Combine first and last names into a full name.
2. Text Manipulation: Append prefixes or suffixes to existing text.
3. Custom Descriptions: Create detailed descriptions using multiple strings.

Related Articles

• Working with Text Functions in Google Sheets: A Comprehensive Guide
• 10 Essential Google Sheets Formulas Every User Should Know