I need a way to find the cell containing ":" in a row and copy it to a new
column.

I would think it should be simple, I just can't figure it out right now.