Cell Merging

[Sudipta Sen]

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

 

[Ms-Exl-Learner]

Use this formula in Sheet2 A1 cell.

=Sheet1!A1&" "&Sheet1!B1

If this post helps, Click Yes!