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

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