CONCATENATE/LEN formula in excel

The CONCATENATE formula in Excel is used to join together text strings from different cells into one cell. For example:
`=CONCATENATE(A1, " ", B1)`
This formula would combine the text in cell A1, a space, and the text in cell B1. Alternatively, you can use the "&" operator:
`=A1 & " " & B1`
Both formulas would achieve the same result.
#exceltutorial #viral