Friday, 3 June 2016

How to combine two excel columns in to one?

Or, How to add two columns in Excel Sheet?
Or, Excel formula to combine two excel cells in to one.

1.  Click the cell where you want to put the combined text.
2.  Type =(
3.  Click the cell that contains the first text you want to combine > type &” > Type “& > Select the          next cell text you want to combine > Type ) > Press Enter
     e.g. In my case, =(C15&” “&D15
4.  Type &” “&  (a space enclosed in quotation marks).

Reference screenshot is given below:

No comments:

Post a comment