Concat Formula in MS Excel

Concat Formula in MS Excel

The Concatenate (CONCAT) formula in MS Excel allows you to combine text from two or more cells into one cell. 

The formula is as follows:

=CONCATENATE(text1, [text2], ...)

Where:

1. text1: The first text string to be combined.
2. text2, ...: Optional. Additional text strings to be combined.

For example, if you have two cells with the text "Hello" and "World" respectively, the formula to concatenate the two cells into one cell would be:

=CONCATENATE(A1, " ", B1)

This would return the result "Hello World". The " " in the formula is a space, which is used to add a space between the two strings.

Note: In Excel 365 and later versions, the CONCATENATE formula has been replaced by the more user-friendly "&" operator. You can use this operator in the same way as the CONCATENATE formula:

=A1 & " " & B1