Hello,

I am looking to copy and paste certain cell containing a specific phrase. For example, say I want to copy all cells in one column that contain the phrase farm somewhere in the cell. It could say farm, farmer, or farmers, but I want to select anything that says farm in the cells in the column. Do you know how I could do this? Also, I have Microsoft Excel for Mac Version 15.15 if that helps.

Thanks!