Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature and Paste Link
I have a spreadsheet that one entire column populated by a paste link to
another spreadsheet. I am attempting to do a find on that column and it will not find the text that is returned. Is there another way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature and Paste Link
What are you looking for?
Are you sure that there is a match? Erika wrote: I have a spreadsheet that one entire column populated by a paste link to another spreadsheet. I am attempting to do a find on that column and it will not find the text that is returned. Is there another way to do this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature and Paste Link
If I do a search for the word Texas - I will be looking right at the word
Texas and it will not find it. Obviously what is really in the cell is a paste link example ='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9 but it returns the word Texas. "Dave Peterson" wrote: What are you looking for? Are you sure that there is a match? Erika wrote: I have a spreadsheet that one entire column populated by a paste link to another spreadsheet. I am attempting to do a find on that column and it will not find the text that is returned. Is there another way to do this? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature and Paste Link
Are you matching the entire cell (maybe there's a extra space character???).
Are you looking at formulas or values? Show the Find dialog and click on the options button to see if you can toggle one of those settings to get it to work. Erika wrote: If I do a search for the word Texas - I will be looking right at the word Texas and it will not find it. Obviously what is really in the cell is a paste link example ='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9 but it returns the word Texas. "Dave Peterson" wrote: What are you looking for? Are you sure that there is a match? Erika wrote: I have a spreadsheet that one entire column populated by a paste link to another spreadsheet. I am attempting to do a find on that column and it will not find the text that is returned. Is there another way to do this? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature and Paste Link
ps. In xl2002+, you can find based on format, too. Make sure you clear the
formatting, too. Dave Peterson wrote: Are you matching the entire cell (maybe there's a extra space character???). Are you looking at formulas or values? Show the Find dialog and click on the options button to see if you can toggle one of those settings to get it to work. Erika wrote: If I do a search for the word Texas - I will be looking right at the word Texas and it will not find it. Obviously what is really in the cell is a paste link example ='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9 but it returns the word Texas. "Dave Peterson" wrote: What are you looking for? Are you sure that there is a match? Erika wrote: I have a spreadsheet that one entire column populated by a paste link to another spreadsheet. I am attempting to do a find on that column and it will not find the text that is returned. Is there another way to do this? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Feature and Paste Link
Sure enough - it is looking at Formulas - I can not believe I missed that.
Thank you for your assistance. "Dave Peterson" wrote: Are you matching the entire cell (maybe there's a extra space character???). Are you looking at formulas or values? Show the Find dialog and click on the options button to see if you can toggle one of those settings to get it to work. Erika wrote: If I do a search for the word Texas - I will be looking right at the word Texas and it will not find it. Obviously what is really in the cell is a paste link example ='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9 but it returns the word Texas. "Dave Peterson" wrote: What are you looking for? Are you sure that there is a match? Erika wrote: I have a spreadsheet that one entire column populated by a paste link to another spreadsheet. I am attempting to do a find on that column and it will not find the text that is returned. Is there another way to do this? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
How do I activate the Link feature? | Excel Worksheet Functions | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
how to change "Find" feature | Excel Worksheet Functions |