Hi everyone,

I have text data in a column in a worksheet (which can sometimes be more than 255 characters). I want anything that shows up in this column to show up in another column in another worksheet within the same workbook, BUT I would like for all blank cells to be removed when it goes over to the other column. Any ideas?

Thank you very much.