Pasting data without removing formulas

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

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

"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

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.

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


"bigwheel" wrote:

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

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

You are welcome. Thanks for the feedback.

"rayteach" wrote:

> 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