As long as there are no blanks in A!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Pete_UK" wrote in message
oups.com...
If you select cell B1 you will see a small black square in the bottom
right hand corner - this is called the fill handle, and if you have
data in the column next to it (as you have), then all you need to do is
to double-click this square. The formula will be copied down to the
bottom of the data in the next column.

Hope this helps.

Pete