Find text and copy elsewhere

  • Thread starter Thread starter QPapillon
  • Start date Start date
Q

QPapillon

Hello,

I would like to find all instances of a specific word in a column of approx.
1200 rows and copy them in either another row/sheet.
I tried the autofilter but it didn't seem to work.

Any suggestions?
 
QPapillon said:
Hello,

I would like to find all instances of a specific word in a column of approx.
1200 rows and copy them in either another row/sheet.
I tried the autofilter but it didn't seem to work.

Any suggestions?
Click to expand...

What do you mean didn't work? What were the result? Is the word a single
word in the cell or is it included in a string of text?

gls858
 
Hi,

It's a single word in a string of text, i.e. I want to search for all
instances of the word "upgrade" in a bunch of comments.

I tried auto-filter and it picked the first sentence with the word in it and
then it showed a whole bunch of other ones that didn't have the word...
 
QPapillon said:
Hi,

It's a single word in a string of text, i.e. I want to search for all
instances of the word "upgrade" in a bunch of comments.

I tried auto-filter and it picked the first sentence with the word in it and
then it showed a whole bunch of other ones that didn't have the word...
Click to expand...
I that case auto filter will not work. Take a look at Don's suggestion.

gls858
 
How did you use Autofilter?
Click the Autofilter down-arrow select 'Custom' (third item down),
On the left, change 'Equals' to 'Contains'.
On the right, type "upgrade", click OK
Does this work?

George Gee
 
Back
Top