Is it possible to transfer all the found cells to another column in Excel?

Question

excel

Through the built-in exel function: find and replace, I found the cells of interest to me, and now I want to transfer all of them to a separate column. Is it possible?

Answer 1

With basic Excel tools, this can only be done if the results are in one column: select all rows in the search results via Ctrl + A, then close the search window, copy the selected cells and paste them into the desired column.
If the data is in different columns and there are few columns, then you can repeat the procedure above, limiting the search to one column.
If there are many columns, then
either a formula, for example, like here: stackoverflow.com/questions/14731185/find-results-...
or a macro, for example, like here: answers.microsoft.com/en-us/office/forum/ office_20...