Oops! You have large excel worksheet and need to combine multiple cell into one cell; what will you do? Will you do cut and paste from one cell other cell? No please don’t do this it will take lot of time and energy, I will shows easiest way to combine or merge multiple cell text into one cell without doing any hard work.
1. Keep the cursor on cell type (=) move cursor on cell insert (&” “&) again move the cursor on second cell and hit “enter” in short the formula is (=A1&” “&A2)
2. For number combining type (=A1&A2)