The most commonly used text function of Excel is CONCATENATE. This brilliant function join text together into one cell. This is typically a combination of written text, and text that is contained with cells on the spreadsheet.
The example below is a typical example of CONCATENATE. In this example, it is being used to join the first name and last name and insert a space in between. The formula below is written in cell C2.
This blog post uncovers 4 amazing tips to take your CONCATENATE functions to the next level. Continue reading