Thank you so much. That is what I thought and you have confirmed.
--
ray


"IanRoy" wrote:

A formula operates on data in other cells from where the formula is, and
shows the results in the cell containing the formula. Paste elsewhere. Use
the cell where the pasted data will go as a reference in your formula.

"rayteach" wrote:

Using Excel XP. I have a spreadsheet with formulas and I want to import data
from a web site into those cells with formulas. In other words, I want the
formulas to operate on the imported data. Is this possible to do or will the
paste command always place the data in the cell and remove the formula?
--
ray