Find All

  • Thread starter Thread starter Saxman
  • Start date Start date
S

Saxman

Is there a means of copying the contents of the Find All operation and
pasting into another worksheet for analysis?

TIA
 
Hi,

Am Wed, 19 Mar 2014 00:25:29 +0000 schrieb Saxman:
Is there a means of copying the contents of the Find All operation and
pasting into another worksheet for analysis?
Click to expand...

filter for your search value and copy the visible range.
If that is not a solution please explain more. What is your range? What
are you looking for? Is that search value in rows or in columns? What
should be copied?


Regards
Claus B.
 
Hi,

Am Wed, 19 Mar 2014 00:25:29 +0000 schrieb Saxman:


filter for your search value and copy the visible range.
If that is not a solution please explain more. What is your range? What
are you looking for? Is that search value in rows or in columns? What
should be copied?


Regards
Claus B.
Click to expand...

I'm highlighting a column text and maybe looking for a word 'but' for
instance using Find and Replace. I select the Replace tab. Insert the
word 'slow' in the 'Find what' field and select the button Find All.

Sure I get all the examples of 'but' listed below upon execution which
are all hyper-linked to their respective locations.

There are plenty formatting options, but no means of copying. Tried
Ctrl+C, but that doesn't work.
 
Hi,

Am Wed, 19 Mar 2014 10:03:44 +0000 schrieb Saxman:
I'm highlighting a column text and maybe looking for a word 'but' for
instance using Find and Replace. I select the Replace tab. Insert the
word 'slow' in the 'Find what' field and select the button Find All.
Click to expand...

filter your column for "slow" and copy the visible cells.


Regards
Claus B.
 
Hi,

Am Wed, 19 Mar 2014 10:03:44 +0000 schrieb Saxman:


filter your column for "slow" and copy the visible cells.


Regards
Claus B.
Click to expand...

I cannot do that because the word 'slow' is contained within a sentence.
 
Hi,

Am Wed, 19 Mar 2014 10:57:28 +0000 schrieb Saxman:
I cannot do that because the word 'slow' is contained within a sentence.
Click to expand...

you can use Filter => Text filter => Contains "slow"
If this in not helpful, please post some examples of your strings


Regards
Claus B.
 
Hi,

Am Wed, 19 Mar 2014 10:57:28 +0000 schrieb Saxman:


you can use Filter => Text filter => Contains "slow"
If this in not helpful, please post some examples of your strings
Click to expand...

That's exactly what I did Claus. A far better way to filter text!

I am now able to filter horse racing comments and look at the results in
other columns. Very useful.

Thanking you very much Claus.
 
Back
Top