Need to clear column of text in large array. Where cell is blank, go to next
cell (down). where cell contains text, go to next column (right) and append
to contains of column two cell continue this loop until end of range. I am
brand new at VBA. Can anyone help?