The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

We can use two functions to add a prefix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function. Eg. We are creating the ...

where arguments are character matrices or quoted literals. The CONCAT function produces a character matrix containing elements that are the concatenations of corresponding element strings from each ...