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

If you do this on a regular basis you can record a macro and use that to do
this in the futu

Select your range of cells, assume it's C1:Z100
Hit function key F5
Click SpecialBlanksOK
Goto EditDeleteShift cells leftOK

Biff

"shnim1" wrote in message
...

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




--
shnim1