If conditional copying of URL to another cell?

Formulas and functions can't MOVE data from it's original position, it can only show you new data based on the original data. Moving the original data would require some manual steps, or VBA programming.

If the list is in column A, this formula will create a list in column B with blank spaces, in B1 and copied down:

=IF(ISNUMBER(SEARCH("forum", A1)), A1, "")



If you want a list with no spaces, you will need an array formula and a specified range of cells. In B1 enter this array formula:

=IFERROR(INDEX($A$1:$A$6, SMALL(IF(ISNUMBER(SEARCH("forum", $A$1:$A$6)), ROW($A$1:$A$6), ""), ROW($A1))), "")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Now copy B1 down a ways until the answers stop appearing.

The second will work, but you have to do the Control+Shift+Enter together properly to activate the array. If you just press ENTER it won't work. CTRL+SHIFT+ENTER and then you will see curly braces { } appear around your formula.