Hi all

How can I paste values along side any text etc cells that are to the left.

If I have text or anything in A1 to A20 could be A1 to A17 or T1 to T20 and
B1 or U1 is highlighted is there a way that what I have copied, paste it to
B1 to B20 or B1 to B17 or U1 to U20.

Thanks in Advance