Column data organization

S

shnim1

Hello

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

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

Thanks in advanc
 
B

Biff

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

Select your range of cells, assume it's C1:Z100
Hit function key F5
Click Special>Blanks>OK
Goto Edit>Delete>Shift cells left>OK

Biff
 
Top