Combines several text strings into one string.
CONCATENATE(text1, text2, ... text30)
returns up to 30 text strings text1 - text30, joined together.
text1 - text30 may also be single cell references.
The ampersand operator & may also be used to concatenate text in a formula, without the function.
CONCATENATE("al", "tog", "ether")
"al" & "tog" & "ether"
also returns altogether.
where cell A1 contains key and cell A2 contains board returns keyboard.
CONCATENATE(ROUND(RAND()*10), ROUND(RAND()*10), ROUND(RAND()*10))
returns the text string xyz where x, y, z are three randomly independent digits, while:
returns nnn where n is a random digit repeated three times.
Here Zapof function converts each number given by ROUND(RAND()*10)) to text before concatenating.
CONCATENATE("Print Date: " , TEXT(TODAY(),"dddd, dd mmmm yyyy"))
returns Print Date: Thursday, 9 December 2021 (assuming today's date was Dec 9, 2021). This example serves to demonstrate that you can combine functions in quite complex ways. This example is made up of the date function TODAY() which returns the current date as a number (NOTE: Dec 9, 2021 is represented as 44527) and the text function TEXT() which allows you to format the numeric representation of the date in a useful textual format.