CONCATENATE Function in Excel – using a text function in your spreadsheet

CONCATENATE Function in Excel – how can I use this function in my spreadsheets? Watch the video to learn more

CONCATENATE Function in Excel: Excel iconThis week’s hint and tip is on the CONCATENATE function in Excel. It looks at this function and how it can be used in spreadsheets. This is covered in our Advanced Excel training course so we decided to do a hint and tip on it. We are going to go through it now below.


What is the CONCATENATE Function?

The CONCATENATE function is one of the text functions that are available for use in Excel. This text function allows you to join together a number of text strings to make one text string in a cell. This means that you can join together information from a number of cells to make one string of information in one cell.


Using the CONCATENATE Function

The CONCATENATE function is useful for bringing together information from a number of cells in Excel. When creating a string of text, if you want a space you need to type ” ” in the formula. So a formula bringing together 2 cells with a space in between them would look like this =CONCATENATE(a1,” “,a2). This function is very useful when you have data that you want to merge together. For example, if you have two columns with first and last names in them but want a column with the full name in it you can use this function to do that.


The video below shows you how to use CONCATENATE in Excel. It goes through what this function does in the spreadsheet and how to use it.

Take a look below at the video to find out more and then try it out on your own computer!

We hope you have enjoyed this hint and tip on the CONCATENATE function in Excel. Why not take a look at our previous one on financial cell formatting types in Excel?