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

This 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 isn’t covered specifically in our courses so we decided to do a hint and tip on it.CONCATENATE Function in Excel: Excel icon 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?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy