DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version

Saturday 21 January 2017

Combine different cells by "&" Operator

In last post we have learn how to merge two cells using CONCATENATE but there is another easy way to combine different cells that is using & operator. This method is very easy as compared to Concatenate because typing the & is much easier and quicker than typing the word "concatenate".

Combining by & Operator

In this method, every thing is same and whole of the working is same but just there is a different in using &, there is not typing of the word CONCATENATE, juts enter EQUAL SIGN and select the cell 1 then press & then select second cell then press & and so one.

The Following is the formula to combine the values using & operator

Combine different cell values without spaces between the values:   =A1&A2&A3

This formula combines the values in one cell but there will be no space or comma or any other symbol. See Below



This is not the perfect way to express any value without space or comma. Lets learn How to insert the comma between the values.

Combine different cell values and separate the values with comma using & operator =A1&","&A2&","&A3

Here we add some more symbol in the formula bar. Now add &","& in the formula between all the values  =A1&","&A2&","&A3



All the values separated by Comma is much better than other,  but still there is lack of space after every comma. See below



so we insert space formula after comma than it look more attractive and official like this
(Zahid, MBA, GCU), lets learn how to do this.

Combine different cell values into one cell separated by spaces =A1&", "&A2&", "&A3
See Below


In last formula we have inserted "," in bar to insert comma. but now we will insert  ",  " (Space after comma) after every value =A1&", "&A2&", "&A3

The Following is the actual formula inserted in worksheet. See


In above picture you can see the formula separated by comma and space.

Yes and Done, this is the perfect and official format used every where like (Zahid, MBA, GCU)

Click Here to learn Combining by Concatenate Function