Cell Merging
 

If I entry Data in A1 & B1 on sheet 1

I want to get Meging data of A1 & B1 in A1 on Sheet 2, eg.

Sheet 1
A1 B1
Kolkata 700 001

Sheet 2
A1
Kolkata 700001

Is it possible, if yes how?

Thks & Rgds.
Sudipta

Cell Merging
 

Use this formula in Sheet2 A1 cell.

=Sheet1!A1&" "&Sheet1!B1

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Sudipta Sen" wrote:

If I entry Data in A1 & B1 on sheet 1

I want to get Meging data of A1 & B1 in A1 on Sheet 2, eg.

Sheet 1
A1 B1
Kolkata 700 001

Sheet 2
A1
Kolkata 700001

Is it possible, if yes how?

Thks & Rgds.
Sudipta