concatenation Resources

The concatenate function quickly links the content of two or more cells The concatenate function in Excel allows you to join text strings from different cells (like first name and last name) which can be very useful. It can be used with a number of other Excel functions. You can concatenate in Excel by using the Concatenate function […]

Today I wanted to be able to show the text which was stored in another cell, within a ‘string’ of text. I wanted to have a name ‘John’ as plain text in cell C3. In cell A1, I wanted to be able to display ‘Hello <whatever is in cell C3>’. My colleague Doug here at […]