Pasting data without removing formulas

R

rayteach

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?
 
I

IanRoy

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.
 
B

bigwheel

rayteach said:
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?
Click to expand...

It is not possible to have data and formulae in the same cell. You should
import your data intoseparate cells or sheet and use the formulae to
manipulate the data.
 
Top