Hello

I have data in a worksheert that is randomly scattered throughout a hundred rows and several columns (C through Z). Each row is a mix of numbers and empty cells. I need to condense each row of information so that all the empty cells are removed and the information is condensed to the left.

I wasnt sure weather VBA or formulas would be the best way to go. If anyone knows of a method, it would be greatly appreciated.

Thanks in advance