2009 22 Nov

How To Concatenate Data In Microsoft Excel 2007

no comment Posted by free recipes

Combining existing data in different cells to form new information is a not infrequent requirement in MS Office Excel 2007. Concatenation is the process of stringing together different pieces of information to form a new piece of data. For example, if we have columns containing people’s title and first name and another containing their last name, we could use concatenation to create their full name. All we need to do is to string together the title, first name and last name.

Excel offers two concatenation techniques. The first is to use ‘&’ (the ampersand) which is the concatenation operator: the second is to use the CONCATENATE function. To use the ampersand in our Full Name example, we would first enter an “=” sign to indicate to Excel that we want to create a function. Secondly, we would click on the cell containing the title to enable Excel add a reference to that cell to our formula.

Next, we must add a space to separate the title from the first name. To do this, we type the concatenation operator followed by a space. However, since a space is a character, it has to be enclosed in quotation marks. Thus, we would type ‘& ” ” &’. Now we click on the cell that contains the first name, then type ‘& ” ” &’ once more to add a space between the first name from the last name.


To finish, we click the cell that contains the last name and, to confirm the formula, either press the Enter key or click on the Enter button on the left of the formula bar.

Now let’s look at doing the same thing using the CONCATENATE function. When using the Insert Function command, this is found in the Text category and permits you to string together up to 255 pieces of information. For example, let’s say that our title was in cell C2, our first name in D2 and our last name in E2; our formula would be ‘=CONCATENATE(C2,” “,D2,” “,E2)’.

As to which is better; there is not much to choose between them. Simply use the one which you feel makes more sense to you. One argument for using the first method is that the use of the concatenation operator is found in most scripting and programming languages. Some environments use the ampersand; others use the plus sign.

Are you looking for training on Excel 2007. We offer Microsoft Excel 2007 courses in London and all over the UK.

Possibly related posts: (automatically generated)


  • Share/Save/Bookmark
Published under Computers | send this post
Tags: , , , ,

No User Responded in " How To Concatenate Data In Microsoft Excel 2007 "

Subscribes To Comments Post Rss or Leave A Trackback To This Post
You must be logged in to comment.


create & buy custom products at Zazzle


The people in the village were real poor, so none of the children had any toys. But this one little boy had gotten an old enema bag and filled it with rocks, and he would go around and whap the other children across the face with it. Man, I think my heart almost broke. Later the boy came up and offered to give me the toy. This was too much! I reached out my hand, but then he ran away. I chased him down and took the enema bag. He cried a little, but that's the way of these people...
by Jack Handy



Search The Web