Select data based on content, cut content, and move to new cell

I am looking to select data based on a given criteria. Let's say that I want to select all the cells that contain the word "CHAPTER". After these cells are selected, I want to cut/delete the content of these cells and paste them into a another location within the spreadsheet. How do I do this?

Hi,

Try the following N steps:

1. Assumimg the data starts in cell A1, enter the following formula into the first cell in the first available column =IF(ISERROR(SEARCH("Chapter",A1)),2,1) to the rigt of the dataset
2. Copy this down the entire range
3. Sort the entire dataset by this column
4. Move (CTRL + X) the range flagged by a 1 to the desired location
5. Delete any columns with the sort flag if need be

Hope this helps.

Kind regards,

Robert