Examples of Excel Concatenate formula

What is the use of Concatenate formula?

Adds a bunch of text values to one another

Syntax of Concatenate formula:
concatenate(this, [to this..])

Examples of Excel Concatenate formula:
concatenate("one ","big ","text") = one big text
concatenate(A1,A2,A3) = adds the text values in A1,A2 and A3

<< Sum I Concatenate I Find >>




That’s all for now. If you want to add any tip then feel free to comment below. Thanks. And Subscribe to blog feed to receive updates about new posts !