Thank you Brian. From you information I found that I can type the name of the
column in the cell over the name of the column that was created when the paste
Special was done. I then drag the cell with the name I typed in to the cell
below (to the cell with the name of the column created by the Paste Special).
The name of the column is now capable of being found by the Find & Replace
function.
Brian Barker <[EMAIL PROTECTED]> wrote: At 15:02 04/12/2007 +0000, Brian Barker
wrote:
>At 06:33 04/12/2007 -0800, Walter Hildebrandt wrote:
>>Under Options "Link" is selected. Under Selection "Paste all" is
>>selected. I am copying a column that has formulas in it. The
>>answer to the formula is Pasted, not the formula itself. At the
>>top of the heading is a name. The name which is text can not be
>>found with the "Find & Replace" function.
>
>If you paste a link, you don't have the results of any formulae, in
>fact, but simply new formulae that refer back to the cells that are
>the source of your copy and paste. And it's not surprising that you
>cannot find the text with the Find function, since the text that you
>see doesn't actually appear in that cell - only a formula whose
>result is that text.
>
>If you really want a link there instead of a copy of the content of
>the original cells, it doesn't make sense to want to replace
>anything anyway. Conversely, if you want to modify the copy,
>perhaps you don't want a link in the first place. Untick the Link
>option in the Paste Special: does that help? Or perhaps what you
>may really need is a link to the column of formulae but separately a
>copy - not a link - of the cell containing the heading. Then you
>can sensibly search for and modify that heading.
Actually, I wasn't being as helpful as I might have been here. You
can find text in the cells containing links, in fact: you just need
to choose the appropriate option. By default, Find searches in
formulae rather than in their results. To search the results of
formulae (as your text here is), choose More Options in the Find &
Replace dialogue, and then choose Values in the "Search in" drop-down
menu. This is the answer to your original question, of course.
I trust this helps more than my previous effort.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
