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