How to Copy Rows If Column Contains Specific Text in Excel

This post will guide you how to copy rows if column contains a specific text or value in Excel. How do I find a specific text or values in a column, and the copy rows which contain that given text or values in Excel.

Copy Rows If Column Contains Specific Text


Assuming that you have a list of data, and you want to find a text string “excel” in the first column, and then copy all rows which contain “excel” text. How to achieve it. You can use the Filter function to achieve the result of filtering out all rows that contain specific text “excel”. Just do the following steps:

#1 select one column which you want to filter.

copy rows if column contain specific value1

#2 go to DATA tab, click Filter command under Sort & Filter group.

copy rows if column contain specific value2

#3 click on the arrow button on the first cell in the filter column. And click the Text Filters form the drop down menu list, and select Contains. And the Custom AutoFilter dialog will open.

 

copy rows if column contain specific value33

#4 type that specific text “excel” into the second text box. And then click OK button.

copy rows if column contain specific value4

#5 you can select all filtered out rows, and press Ctrl + C to copy the selected rows.

copy rows if column contain specific value5

#6 select a blank cell or row, then press Ctrl + V to paste the selected rows.

copy rows if column contain specific value6

Video: Copy Rows If Column Contains Specific Text

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar