Combine excel cell values

How to combine excel values from different cells?

Combining values in excel saves time of course, unless you like to buy some time to drag the work and keep yourself busy.

But how to combine values using excel formula?

If you have data of first name and last name in different cells and you want to combine those values in another cell without re-typing the data. This formula below will come handy.

Let’s assume this value:

A1 – contains first name

B1 – contains last name

D1 – will contain the combine cell values in first name and last name format

D2 – will contain the combine cell values in last name, comma and first name format.

For cell D1 the formula is: =A1&" "&B1 (Notice the space in between the “&” (ampersand sign) if it is a double space the combine value will have a double space)

For cell D2 the formula is: =B1&", "&A1 (Notice that the cell address has been reverse and the comma after cell B1.


That’s it those simple formula will save you some time, if the range is quite long just copy and paste the formula will automatically increase the cell address.

See screen shot below:

To combine 3 cell values to a single cell use this formila:

=A1&" "&"B1" & C1


Notice the  space before C1, it will give a single space after the value of B1.

Formula above will get values of A1, B1 and  C1 and the cell that contains the formula will hold the value of the 3 cells.


Cheers.. Hope it helps.. :)  

----------------------------------
Free Android app, download at Google play:
Android Divine Mercy Chaplet Guide  
https://play.google.com/store/apps/details?id=com.dmercyapp