Use the CONCAT function

The CONCAT function combines text from multiple ranges and/or strings. 

CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility.

CONCAT(text1, [text2],…)

• text1 (required) Text item to be joined. A string, or array of strings, like a range of cells.

• [text2, ...] (optional) Additional text items to join, up to 253 text arguments.

For example, =CONCAT("The"," ","sun"," ","came"," ","out"," ","today.") returns The sun came out today.

For more info, see CONCAT function.

Tip: Use the ampersand & to concatenate strings. ="Sun's"&" "&"out" displays Sun's out. 

The CONCAT function combines text from multiple ranges and/or strings. 

CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility.

CONCAT(text1, [text2],…)

• text1 (required) Text item to be joined. A string, or array of strings, like a range of cells.

• [text2, ...] (optional) Additional text items to join, up to 253 text arguments.

For example, =CONCAT("The"," ","sun"," ","came"," ","out"," ","today.") returns The sun came out today.

For more info, see CONCAT function.

Tip: Use the ampersand & to concatenate strings. ="Sun's"&" "&"out" displays Sun's out. 

The CONCAT function combines text from multiple ranges and/or strings. 

CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility.

CONCAT(text1, [text2],…)

• text1 (required) Text item to be joined. A string, or array of strings, like a range of cells.

• [text2, ...] (optional) Additional text items to join, up to 253 text arguments.

For example, =CONCAT("The"," ","sun"," ","came"," ","out"," ","today.") returns The sun came out today.

For more info, see CONCAT function.

Tip: Use the ampersand & to concatenate strings. ="Sun's"&" "&"out" displays Sun's out.