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.

I have a simple sub procedure in Excel (XP) that returns the total ... I did not use the built-in CONCATENATE() function because it won't accept cell ranges and I don't want to sit there and ...

It’s not something you’d need to do in Microsoft Excel, but the next person down the line might need it ... be wondering about Excel’s CONCATENATE() function, but you must reference each ...

Joining or merging two columns together in Excel is something every business owner will need to do eventually. If you're importing data from another source, like a CSV file containing prospect ...

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 ...