You are here

Home

10 - Merging content in Excel - CONCATENATE ()

CONCATENATE in Excel combines content of different cells into one unit respectively one sentence.

Example:

= concatenate (A1, "a", B1) - the result is as follows - Paris is a beautiful city.

Function Concatenate in Excel which combines content in Excel

If you copy the formula only cell B will change (gradually B1, B2 and B3), because cell A1 is fixed while the text in  " " always remains unchanged.

Function Concatenate in Excel is very handy and has a big importance with combination with more advanced functions as VLOOKUP, COUNTIF, etc. 

Partner sites:

kosime.sk
Kosenie trávy, čistenie pozemkov a záhradnícke práce