Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel find text and copy rows
I want to find all rows in a worksheet that contain a particular word, and
copy those rows into a blank new worksheet. Thanks for advice. |
#2
|
|||
|
|||
If the word in question is in the same column of data, you could use
autofilter to find the word. Select the headers for the columns you are reviewing and Data - Filter - Autofilter On the down arrow that's displayed at the top of the column in question, select CUSTOM and show rows where "Column Name" CONTAINS "word" "Denys-mark" wrote in message ... I want to find all rows in a worksheet that contain a particular word, and copy those rows into a blank new worksheet. Thanks for advice. |
#3
|
|||
|
|||
That's very helpful.
The target word could actually be in one of two columns, but I can do the custom autofilter you suggested twice, once on each column, and get managable results. Thanks "Barb Reinhardt" wrote: If the word in question is in the same column of data, you could use autofilter to find the word. Select the headers for the columns you are reviewing and Data - Filter - Autofilter On the down arrow that's displayed at the top of the column in question, select CUSTOM and show rows where "Column Name" CONTAINS "word" "Denys-mark" wrote in message ... I want to find all rows in a worksheet that contain a particular word, and copy those rows into a blank new worksheet. Thanks for advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import only certain rows of a huge text file | Excel Discussion (Misc queries) | |||
Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) | |||
How do I copy a Word text file into Excel in a way that each char. | Excel Discussion (Misc queries) | |||
How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |