I have a worksheet that is totally generated with formulas and would like to remove and shift up any cell that does not contain a value. I have tried copying and pasting special values, but my data is left with extra spaces that disable my conditional formatting. Is there a way to remove spaces before and after a cell value without using a formula to accomplish it? I have already tried text to columns.