Automatic moving cell Info

[Guest]

Hi

If I add a number in cell A2, I want that number that i put into A2 an
the text that I already have in B2 to go to another page in P2. How Can I do
this

Thanks

Troy

 

[Bill Kuunders]

in P2 enter =A2&" "&B2
the middle bit is there to have a space between the number and the text.

If a2 and b2 are on different sheet..........
=Sheet2!A2&" "&Sheet2!B2

 

[Gord Dibben]

Troy

To actually "move" the data would require VBA because functions and formulas
cannot move anything.

If you just want the data to appear in P2 on another worksheet..............

In P2 enter =Sheet1!A2 & Sheet1!B2

With a space =Sheet1!A2 & " " & Sheet1!B2

No error check for blank cells.


Gord Dibben MS Excel MVP