The concatenate function may not be as well have intercourse as other common Excel features such as IF and VLOOKUP , but it ’s still effective , even though it execute a more simple function in nature . If you areusing Microsoft Excel , you’re able to use concatenate to merge the information you have inserted into columns into a exclusive cell or column . For example , you could combine columns detailing tax revenue and profit for a throw month into one cadre .
Concatenate conflate datum from two or more cells or pillar into a third . While similar , it is not the same asmerging cells in Excel . That is a formatting feature , whereas concatenate is a data analysis instrument .
Let ’s take a look at how to use concatenate in Excel .
Using the concatenate function for two columns in Excel
Step 1 : Select the column and cellular telephone in which you ’ll be blend datum from other cells . For demonstration function , I will be using concatenate in the column neighboring to the first two columns that I will be immix , but you’re able to use any placement within your spreadsheet .
Step 2 : I will be aggregate the A2 and B2 cells , so I ’ve typed in = CONCATENATE(A2,B2 ) . This is the most basic form of using the concatenate purpose , but there are ways to custom-make it , which we ’ll go through in dance step 4 .
Step 3 : To substantiate the concatenate formula , just reach the enter key fruit , after which the electric cell you ’ve introduce into the formula will be unite .
Step 4 : As you’re able to see above , the standard concatenate pattern I used combined my data point but it does n’t look quite right .
You may want to insert a space between the datum that is being connect : Type in = CONCATENATE(A2 , " " , B2 ) .
If you want to sum another value , simply type that in between the quotation scrape within that formula . For example , you could furcate the blend datum with the equal sign .
I ’ve added the equal sign and two additional distance between it within the quotations marks to separate the data that has been merge .
footfall 5 : you may further tailor-make the cellphone where the concatenate part is being used by using the standard Excel tools . I ’ve made it bold , centered the textbook , and increased the font size .
How do you concatenate 3 columns in Excel?
you may also use the concatenate function to combine more than two column .
Step 1 : I typecast in = CONCATENATE(A2,B2,C2)into its own cellular telephone . vary the column letter of the alphabet to one of your choosing , and then hit Enter .
Step 2 : If you want to use concatenate for an total pillar , Excel provides an easy root . Just get behind the first cell ’s bottom - right corner that we filled in from footstep 1 using your mouse to wherever you wish the combined information to appear .
How do you concatenate in Excel without a formula?
Step 1 : To concatenate cadre in Excel without using its rule , put down , for example,=A2 & B2 .
This will make unnecessary you from get in the convention itself , which , in this case , would be = CONCATENATE(A2,B2 ) .
Step 2 : As is the grammatical case with confirming the concatenate formula , push the Enter button .
For more guides on Excel and its other functions , head over to our articles explaininghow to make a graphandhow to alphabetise data in a spreadsheet .
