Concatenate Excel Formula




Excel Formulas > Text Functions > CONCATENATE

« Sum | Concatenate | Find »

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

Buy Excel Formula E-book | Learn more about Excel Concatenate Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook