What does concatenate mean in Excel?
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Topics » What does concatenate mean in Excel?

What does concatenate mean in Excel?

The concatenate function is one of Excel's text functions. It is used to join two or more words or text strings together.

For example, sometimes data distributed over multiple columns in an excel spreadsheet is more efficient to use when combined into one column.

Let us say that you have two columns containing employee names, the first column contains the First Name and the second column contains the Last Name. You can use the concatenate function to join these two names placing the result into into one cell. The formula will look something like this:

=CONCATENATE(A2," ",B2) where A2 is the first name and B2 is the last name. The " " adds a space between the two names. The result showing the full name could be placed in C2 and then copied down to show all the other full names.

The same result can be achieved without actually using the concatenate function. Instead type =A2&" "&B2 into cell C2. The & characters join the cell values together with a space in between.

Another example would be to create company email addresses based on staff names. For example,
=A2&B2&"@companyname.co.uk"

The main benefit for using concatenate is time saving. Rather than typing in 100 full names they can be created simply by copying the formula.

Related forum posts:

What is concatenate and how does it work?

What is Concatenate and how does it work?

Read forum post

 

Concatenate

I am using the concactenate function and have now managed to construct a sentence, by entering cell content in columns A - M, placing " " in alternate text_line no to represent spaces. I now need to insert a new columm to be new column A. How can I refresh concactenate function so that the new A column/cell content is at the beginning of the constructed sentence? Regards Amanda

Read forum post

 

Adding strings to formulas

how to add strings

Read forum post

 

Text function and combining columns

how do i combine two columns into one?

Read forum post

 

Related articles

How to Create Better Excel Spreadsheets: Part Two

Read article

 

Some Examples Of Excel Text Formulas

Excel is designed to work with a range of formats including numbers, dates, times and text. There are therefore many formulas which specifically enable the user to analyse and manipulate text type data. This article looks at some of those formulas and explains how to use them.

Read article

 

Defining a Project's Success

Read article

 

How To Use Excel To Create Large SQL Insert Statements

When adding records to a SQL database, data is often given in the format of an excel spreadsheet and it is up to the user to import the data into the database. It is impractical and time consuming to update an individual insert statement for each record. Instead, use excel as a resource to quickly and simply create a series of Insert statements which will also minimise human error.

Read article

 



MS Project training
Course rating
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom