Find All

[Saxman]

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

TIA

 

[Claus Busch]

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?

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.

 

[Saxman]

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.

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.

 

[Claus Busch]

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.

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


Regards
Claus B.

 

[Saxman]

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.

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

 

[Claus Busch]

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.

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


Regards
Claus B.

 

[Saxman]

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

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.