Cell Merging

S

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
 
M

Ms-Exl-Learner

Use this formula in Sheet2 A1 cell.

=Sheet1!A1&" "&Sheet1!B1

If this post helps, Click Yes!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Cell data entering slow! 0
Code to format cells on several worksheets 2
column filter 1
Excel - Wich Function should I use? 1
If, Or, and 5
Found few bugs in my daily routine of work in excel for MAC 0
If Function neglecting 0 as a number 1

Top