Merge two cells into one cell

A new Microsoft Excel trick that I've discovered recently.

I need to merge multiple cells into one cell. Instead of wasting time, using notepad and replace here and there, I use a formula with the ampersand (&) operator to combine text from multiple cells into one cell.


how-to:

1. At the formula bar, type =.
2. Select cell in which you want to combine i.e U2. The formula bar will show =U2.
   
3. Type &""&. If you want to make space between the two cells, you make a space or any other character between the question mark. Example, &" "& or &","& or &" + "&.
   
4. Then select the next cell that contains the text that you want to combine i.e V2.
5. The formula looks like =U2&""&V2. Press Enter to see the result.

Kerana trick yang menyenangkan ini, I've rewarded myself with satay, murtabak ayam and happily touring pasar malam with my son, Iman. But woke up late this morning. Haha.