If your data is in column A and your formula is in column B, simply
double click on the small square in the lower right corner of the cell
pointer. This will auto fill your formula down only as far as there is
data in column A

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469295