In C1, type =*A1 & " " & B1*
Now hover your cursor over the bottom right hand corner of cell C1 and
you will see the cursor change to a cross. Now either:
1. click (& hold) and drag downwards to copy the formular down the
page
OR (and this is good)
2. double click the cross!
This last one depends on you using good Excel practice which is no
blank rows or columns in your data otherwise strange - and very
irritating - things can happen.
HTH
Martin
--
MartinShort
Software Tester
------------------------------------------------------------------------
MartinShort's Profile:
http://www.excelforum.com/member.php...o&userid=22034
View this thread:
http://www.excelforum.com/showthread...hreadid=553792