in X1:

=IF(ISNUMBER($B$1),A1,"")

copy across to Y & Z

HTH

"againstallodds1606" wrote:

I want the contents of 3 cells to move when i add a number in one of them.
e.g
Permanant info in A1 & C1. When I put a number into B1 I want the info in
A1 B1 & C1 to show in X1 Y1 & Z1.
Is that possible
Many thanks