Where is concatenate in excel 2010

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. There can be up to strings that are joined together, up to a maximum of 8, characters. Type of Function Worksheet function WS.

Let's look at an easy example. Instead our result would appear as follows: "DigMinecraft. And since is a really big number and in real-life tasks someone will hardly ever need to combine that many strings, the difference boils down to the comfort and ease of use. So, simply stick to the concatenation technique that you feel more comfortable with. In your worksheets, you may often need to join values in a way that includes commas, spaces, various punctuation marks or other characters such as a hyphen or slash.

To do this, simply include the character you want in your concatenation formula. Remember to enclose that character in quotation marks, as demonstrated in the following examples.

The following screenshot demonstrates how the results may look like:. Most often, you would separate the concatenated text strings with punctuation marks and spaces, as shown in the previous example. In some cases, however, may need to separate the values with a line break, or carriage return.

A common example is merging mailing addresses from data in separate columns. A problem is that you cannot simply type a line break in the formula like a usual character, and therefore a special CHAR function is needed to supply the corresponding ASCII code to the concatenation formula:. The merged values are separated with a comma ", " , space " " and a line break CHAR 10 :. Though, an easier way to include printable characters in the concatenation formula is to simply type them in double quotes as we did in the previous example.

In order to concatenate two or more columns in Excel, you just enter a usual concatenation formula in the first cell, and then copy it down to other cells by dragging the fill handle the small square that appears in the lower right hand corner of the selected cell. For example, to concatenate two columns column A and B separating the values with a space, you enter the following formula in cell C2, and then copy it down to other cells.

When you are dragging the fill handle to copy the formula, the mouse pointer changes to a cross, as shown in the screenshot below:. Please note that Microsoft Excel determines how far to copy cells after the fill handle double click based on the cells referred to by your formula. If there happen to be empty cells in your table, say cell A6 and B6 were blank in this example, the formula would be copied up to row 5 only.

On the Home tab, in the Alignment group, click Wrap Text. First, the IF function below finds all members of Team 1. Explanation: the IF function checks each cell in the named range Teams. If equal to the value in cell E3, it returns the name from the named range Names, else it returns an empty string two double quotes with nothing in between.