Rama

There is no formula that will "merge" cells but if you actually mean "combine
data from 2 or more cells into one cell"..........

=A1 & B1 & C1 entered in D1 will combine those three into D1.

If you wish to have a space between enter =A1 & " " & B1 etc.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 00:54:59 -0500, luvrama
wrote:


Hi All,

I need know, whether there is any formula in excel, which will merge
two or more cell?

Can any one help me in this regard..

Thanks,
Rama.