How to Combine text in Excel

Sometimes we have to combine the data of cell in large number which is not possible to do manually. In this Situation this formula can be very helpful.

1. First of all select the cell where you want to put the combined data.
2. Type = and Select the cell you want to keep data first
3. Type & than type quotation mark ” .
4. Again type quotation mark “.
5. Type & Select the second cell.
6. Press enter.