Is it possible to merge cells and keep information from both cells in the new cell?

Hello,

is it possible to merge two cells and keep information from both cells in the new cell?
Or is it possible to solve this in another way?


Example:

Cell1 ---------- Cell2
Banana----------Split

Merged into:

Cell1:
Banana Split

Hello Johda,

If u merge the cells the result is always the information of cell1, what u can do is concatenate the cells using "&" char, loke:

A1 ------- A2 ------ A3
Banana Split =A1&" "&A2

Result: Banana Split

Hi,
You can use event macro (select). If you select cells to merge them, macro takes the values from cells, joins them (A & B) and finally writes A & B in the merged cell.